There have been quite a few queries on the forums this past week with regard to performing fast delete operations on large tables and I wanted to share some of the possible solutions here with you.
Fast ordered delete using a view
To perform a fast ordered delete, take a look at the article Fast Ordered Delete [...]
Posts under ‘Query Optimisation’
Performing fast SQL Server delete operations
What is SQL Server Parameter Sniffing
Have you ever come across a stored procedure that utilises parameters and performs like a dream the majority of the time but for some reason crawls along on some other occasions? Well the chances are that this is down to SQL Server Parameter Sniffing.
I was re-reading through the white paper Batch Compilation, Recompilation, [...]
Hidden RBAR: Triangular Joins
No matter how good a T-SQL programmer you think you are, it is always good to revisit the basics every once in a while and to ensure that you keep your high quality coding standards in check.
One of my favourite series of articles regarding good T-SQL coding practices is by Jeff Moden over at SQLServerCentral.com. [...]