Creating SQL Server tables and columns
Creating and maintaining SQL Server tables isn't a rocket science, or is it? Anyone can use SQL Server Management Studio or the CREATE TABLE statement to put together a collection of columns. How well the tables perform depends largely on choices you make when defining data types, constraints, indexes, file groups where the table is built, as well as partitioning.
Find the rest of this "quick tip" at TechTarget.com.