Tag Archives: SQL Server 2008 R2

Successfully execute an INSERT, UPDATE and DELETE against a Database Snapshot

Not too long ago an ISV that developed solutions using SQL Server as the RDBMS, asked me how they could query a database as at a point in time. This was a relatively easy answer, thanks to the Database Snapshot feature. I was however surprised at the next question “Can we update the database snapshot?” Continue reading

Advertisements
Posted in Thoughts | Tagged , , , , , , , | Leave a comment

Optimize Recursive CTE Query

We recently assisted a global ISV to address a performance issue related to a poor performing recursive CTE (Common Table Expression). The ISV wanted the query that was running in excess of 3 minutes to run in less than 15 seconds on their servers. The end result of our efforts was a 3,600% performance improvement. Continue reading

Posted in Thoughts | Tagged , , , , , , | Leave a comment