Tag: sql server

Community

SQL Server Datatypes

Chosing datatypes for your tables is one of the most basic decisions you will make in database design. Many people discount this part of database planning and take a "close enough" approach. The decisions you make at this stage have far reaching effects that you might not have intended. The

Community

Documenting Database Scripts

One of the things that I see very rarely is script headers and comments. This is baffling. Almost every development project I have ever worked on has had very elaborate version control systems, coding standards, commenting guidelines, and even templates. For some reason, this was never carried th