The Truth - SimonS Blog on SQL Server Stuff

Browse by Tags

All Tags » The Truth (RSS)
16 November 2007 11:31

SQL Server Myths - Disk Queue length a bit like buying Guiness

If you attended SQLBits you may have seen my SQL Myths session. One of the myths I didn't cover was that a Disk Queue length > 2 is bad. Bob Dorr wrote a great blog post on it back in February. I like is analogies. I've got another one. You go into...
Posted by simonsabin | 1 comment(s)
Filed under: ,
20 July 2007 10:32

SQL Server The Truth - Rebuilding a clustered index does not rebuild the non clustered indexes

It used to be fact that the leaf page of a non-clustered index pointed to the row for the page, because it pointed to the file, page and row if the file or page of the row changed the nonclustered index had to be updated. Now however the non-clustered...
Posted by simonsabin | 3 comment(s)
Filed under: , , , , , ,
20 July 2007 09:26

SQL Server The Truth - Instant file initialisation

This is the first in a series of posts that are aimed at dispelling myths and beliefs as to how SQL Server operates. I have interviewed too many people and have been in too many sessions where statements are made as though they are fact when in reality...
Posted by simonsabin | with no comments
Filed under: , ,