Browse by Tags

To cluster of not

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...

Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, Jun 26 2007
Native Command Substitution is not supported

In response to a recent support incident we raised we got a response about use of detours in SQL Server. A detour is a means by which you can change what SQL Server does. This is used by Litespeed to change native backup commands into Litespeed backup commands. Whilst I always thought this a neat idea...

Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, Oct 5 2006

Page 1 of 1 (2 items)

SQL Server Blogs