Browse by Tags

All Tags » Availability (RSS)

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

Service Broker - Reliable processing

I have just finished my presentation on asynchronous process/parallel processing using Service Broker at the Microsoft Technology Conference in Ireland . I was a bit tentative after deciding last night, after a few guinesses and whisky (thanks Barry ...

Restoring and Attaching is a one way street

Many people often ask how they can us a database in SQL 2000 that they have attached or restored to SQL2005. Unfortunately this is a one way street, once upgraded the only way of using a database in a previous version is to copy the schema and data manually...

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