SQL Engine (RSS)

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

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/SQL Server The Truth - Rebuilding a clustered index does not rebuild the non clustered indexes
The new RSS feed is here

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.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SQL Server The Truth - Rebuilding a clustered index does not rebuild the non clustered indexes

posted Friday, July 20, 2007 10:32 AM by SimonSabin with 0 Comments

To cluster of not

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/To cluster of not
The new RSS feed is here

Tony's blogged about the use of heaps http://sqlblogcasts.com/blogs/tonyrogerson/archive/2007/06/24/row-fragmentation-hopscotch-heap-v-clustered-and-io-cost.aspx. Whilst this highlights data on a page being out of sequence and thus yoyoing when you scan the data, it doesn't mean you should always have a clustered index.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/To cluster of not

posted Tuesday, June 26, 2007 1:51 PM by SimonSabin with 0 Comments

What is the cost of a query? Is it a beard?

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/What is the cost of a query? Is it a beard?
The new RSS feed is here

I used to work on a project where we discussed what exactly the cost of a query was. You know that figured shown in execution plans. I knew it was used to age plans in a cache but not sure what unit it actually was. One of the guys on the project (Mike I think) decided to call them "Beards". So we could then say that query x cost 54 beards. Its feels better than saying just 50.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/What is the cost of a query? Is it a beard?

posted Wednesday, April 04, 2007 9:15 AM by SimonSabin with 0 Comments

Online Index White Paper

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Online Index White Paper
The new RSS feed is here

Paul Randal recently informed me of a new white paper on online index operations. The whitepaper can be found here Online Index White Paper.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Online Index White Paper

posted Friday, March 16, 2007 7:27 AM by SimonSabin with 0 Comments

When is full recovery mode not full recovery mode

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/When is full recovery mode not full recovery mode
The new RSS feed is here

I was recently trying to develop a test for DBAs. The scenario of the test was that you have taken over responsibility of a server what needs to be done to make it production ready. The server is really badly configured and the aim is for the tester to find them and make suggestions of what needs to be done.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/When is full recovery mode not full recovery mode

posted Wednesday, December 13, 2006 9:16 AM by SimonSabin with 0 Comments

Checkpointing is now throttled in SQL 2005

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Checkpointing is now throttled in SQL 2005
The new RSS feed is here

During the iinterview with the SQLOS team this morning Slava mentioned that as part of the new design for the SQLOS the checkpoint process is much tightly controlled. If the checkpoint process has issues pages to be written and the latency has become too high (20ms was mentioned) then it will stop issuing pages.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Checkpointing is now throttled in SQL 2005

posted Thursday, November 16, 2006 2:47 AM by SimonSabin with 0 Comments

SQL Engine - Storage of Large Object Data

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/SQL Engine - Storage of Large Object Data
The new RSS feed is here

If you are currently using text, ntext or image data in SQL 2000 and are looking to use "max" data types in SQL 2005 you will be interested in my first article for SQLServerCentral on the use of LOB data.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SQL Engine - Storage of Large Object Data

posted Wednesday, October 04, 2006 8:00 AM by SimonSabin with 0 Comments