September 2008 - Posts

Indexes, Basically - from SQL Bits

I'll put the entire content including as much as I can remember of what I said, the demo code and results onto my web site over the following week or so.
If you'd like the demo databases ( sql 2008 ) there are three, the largest being 60Gb - none really work on a laptop unless you like long waits between queries,
dop me a mail with your address and I'll send a set of native backups with the demo scripts.

( nothing tonight as I'm off to see Metallica at the O2 )

The following cover a few points I raised.

covering clustered indexes

http://sqlblogcasts.com/blogs/grumpyolddba/archive/2008/05/26/covering-clustered-indexes.aspx

size does matter

http://www.grumpyolddba.co.uk/sql2005/working%20with%20indexes%204.mht

( The excel spreedsheet which goes with size does matter)

http://www.grumpyolddba.co.uk/sql2005/working%20with%20indexes%204.mht

Posted by GrumpyOldDBA with no comments
Filed under: , ,