Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

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

3 comments, 1,777 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, 1,171 reads

Posted in A Discussion of SQL Server-Related Topics on 3 October 2012