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 from ‘May, 2009’
Performing fast SQL Server delete operations
SQL Server 2008 Books Online Update
I’m sure that, like myself, you are all big advocates of documentation and that you understand the importance of keeping such literary masterpieces up to date. It may then interest you to know an update to SQL Server 2008 Books Online was released this week.
You can download the update from the following location.
SQL Server 2008 [...]
How to identify the most costly SQL Server queries using DMV’s
I was investigating a performance issue recently and so thought I would share the T-SQL query that I created with you.
There’s nothing new or magic here, the code snippet simply identifies the top 20 most expensive queries (currently cached) based on the cumulative CPU cost.
The query returns both the SQL Text from the sys.dm_exec_sql_text DMV [...]
What does it take to be an outstanding SQL Server DBA?
There has been quite a bit of activity this past week in the SQL Server community regarding how to secure a role as a Junior DBA. Brent Ozar has posted a number of articles here and @SQLBatman has also been busy posting Junior DBA Questions.
Both authors make some excellent points but what if you are [...]
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, [...]