Availability - SimonS Blog on SQL Server Stuff

Browse by Tags

All Tags » Availability (RSS)
20 July 2007 10:32

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...
Posted by simonsabin | 3 comment(s)
Filed under: , , , , , ,
07 June 2007 13:19

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 ...
Posted by simonsabin | 2 comment(s)
Filed under: , , ,
26 May 2007 22:39

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...
Posted by simonsabin | with no comments
Filed under: , ,
05 October 2006 15:29

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...
Posted by simonsabin | with no comments
Filed under: , , , , ,