Summary
In this chapter, you learned about database tables. First, the data types were covered. Selecting the right data type is essential to a well-performing database. The information provided in this chapter will be a helpful reference when selecting data types. The key is to select the data types that will provide integrity, performance, and expansion.
Next, collations were explored in more detail than previous chapters. You learned more about what collations are and the impact they have on the database. You also learned to create the collation configurations for the server instance, database level, and column level.
After collation, you explored table creation through both the Table Designer and the CREATE TABLE T-SQL command. The Table ...
Get SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
