Category Archives: Thoughts

I’ve created categories for that which I think there will be regular content. Oftentimes, I would like to share a thought that hasn’t got a specific place. These will be found under this category.

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

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

“QUOTED_IDENTIFIER” causes Unexpected Query Plan for Persisted Computed Column query

Author: Shaun Tinline-Jones Technical Reviewers: Thomas Kejser, Steve Howard, Jaime Alva Bravo, Kun Cheng, Jimmy May Note: Validation for this post was performed in the SQL CAT Customer Lab on an HP Proliant DL580 G7, Intel Xeon Nehalem E7-4870 2.40 … Continue reading

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