Clear cache for a single Stored ProcedureSometimes for testing purposes (or an emergency) one might find it useful to remove query plan for a single stored procedure. This way...
Partition Tables in SQL ServerThis post is meant to be a quick primer on Table Partitioning in SQL Server. What is it? Let's say you have a large table that is...
Deadlock Error HandlingAn elegant function for a more civilized age: Another way to detect deadlocks is to utilize the TRY CATCH block to raise errors in TSQL...
Parameter SniffingNot always optimal... What is it? Let’s say you have a parameterized proc, and it creates and caches an execution plan based on certain...