Category: General

• Selecting the entire Database as XML String – 2

  

  2012-02-01 - General, XML

  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 [more…]

• The Performance Impact of Forwarded Records on Table Scans

  

  2012-01-31 - General, Performance, SQL Server Internals

  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 [more…]

• How to rollback in procedures

  

  2012-01-23 - General

  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 [more…]

• Selecting the entire Database as XML String

  

  2012-01-13 - General, XML

  I just ran into this question on StackOverflow: Dump data into single XML file from MS SQL Server 2008 R2. In there Daniel is looking for a solution to export his database as an XML file. I thought that request [more…]

• Index Misconceptions [TSQL Tuesday #026 – Second Chances]

  

  2012-01-10 - General, T-SQL Tuesday

  T-SQL Tuesday #26 is hosted by David Howard (blog|twitter). This month’s topic is “Second Chances”. Index Misconceptions The topic this month is “Second Chances” which means that we can write about anything, we would have liked to write about before [more…]