in

SQL Server Community Blogs

Voices of the SQL Server Community

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...
  • 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...
Page 1 of 1 (2 items)
Powered by Community Server (Commercial Edition), by Telligent Systems