Subscribe to this blog
Archives: October 2012
Does a Clustered Index really physically store the rows in key order?
The Myth
One misconception that I see a lot deals with how data is stored in a clustered index. Specifically – is the data in a clustered index stored on the page in physical order? Most people will say “Yes”, and they get this from the definition (see BOL: Clustered… Read more
0 comments, 849 reads
Posted in A Discussion of SQL Server-Related Topics on 21 October 2012
Dealing with orphaned users
The Scenario:
You just restored a production database on a development server. You’ve told the developers that it’s restored, and you start to relax in your chair. 30 milli-seconds later, your phone is ringing… the developers can’t connect to the database that you just restored. You check the server, and… Read more
2 comments, 647 reads
Posted in A Discussion of SQL Server-Related Topics on 3 October 2012