Brad McGehee's SQL Server Challenge:

Stumper #1

Q: Clustered indexes always have to be unique.
A: False

While it is generally a good idea to make all of your clustered indexes unique, it is not a requirement. Clustered indexes can be either unique or not unique. If the clustered index is not created with the UNIQUE property, the SQL Server automatically adds a 4-byte uniqueifier column to the table. And when required, the SQL Server automatically adds a uniqueifier value to a row to make each key unique. This column and its values are hidden and cannot be seen or accessed.

So the correct answer is FALSE.

Whether you're a developer or a DBA or a bit of both, it seems that work is always about being at the top of your game – anticipating problems before they occur. Red Gate has one aim: to help you stay there: at the top.

The single biggest productivity boost is to use tools that are designed, tested and proved to deliver astonishing time-savings in real-world development and administration: tools such as the multi award-winning SQL Compare for database change management. Prove it for yourself.

Red Gate SQL Server Tools
Simple. Accurate. Incredibly fast.

Includes a free trial of SQL Compare