SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond

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 ...