About two weeks ago I wrote about how to get the content of the entire database into an XML document. Today Daniel commented, that he would like the XML to be in a compacter format. In this post I am going to explain how to get there. While WordPress™ conveniently ate the example XML Daniel more »
Forwarded records are a mechanism that SQL Server employs to reduce the amount of maintenance work for indexes on a table without a clustered index. During an update of a record in a table that does not have a clustered index, an increase in size might prevent the record to fit on its current page. more »
On 2/8 I am going repeat my talk about Index Internals at the Philadelphia SQL Server Users Group Meeting. Signup here to attend: http://pssug20120208.eventbrite.com/ TitleIndex Internals – How SQL Server stores and accesses data When02/08/2012 at 17:30 Where Philadelphia SQL Server Users Group Meeting DeVry University Rm 121 1140 Virginia Dr Fort Washington, PA
Jan 232012
Transaction Management The question where in the call stack a transaction should be managed, is similar to the one where errors should be handled. There are several strong reasons to push the transaction management as high up the stack as possible. The most obvious reason is the lack of support for nested transactions in SQL more »
On 1/24 I am going to talk about Index Internals at the SJ SQL Server Meeting. Signup here to attend: http://sjpssug20120124.eventbrite.com/ TitleIndex Internals – How SQL Server stores and accesses data When01/24/2012 at 17:30 Where SJ SQL Server Meeting Haddon Heights Public Library 608 Station Ave Haddon Heights, NJ 08035
