SQL Server Quickie #11 – Non Clustered Indexes
Today I have uploaded the 11th SQL Server Quickie to YouTube. This time I’m talking about Non Clustered Indexes in SQL Server. Thanks for watching! -Klaus
SQLServer
Lock Escalations
In todays blog posting I want to talk about Lock Escalations in SQL Server. Lock Escalations are an optimization technique used by SQL Server to control the amount of locks that are held within the Lock Manager of SQL Server. Let’s start in the first step with the description of the so-called Lock Hierarchy in …
Improving SQL Server Performance by using Instant File Initialization
Today I want to talk about a very specific topic in SQL Server – Instant File Initialization. If you have Instant File Initialization for your SQL Server Instance enabled, you can have a tremendous performance improvement – under specific circumstances. Instant File Initialization defines how the SQL Server engine interacts with the Windows OS, when …
Improving SQL Server Performance by using Instant File Initialization + read more
DELETE operations on tables
In todays blog posting I want to show you quickly about what happens in SQL Server when we are deleting records from a table. Let’s create in the first step a simple table, where 4 records fit onto one page of 8kb. — Create a simple table where 4 records fit onto 1 page CREATE …
Announcing the SQLpassion Performance Tuning Training Plan
You are a developer and/or DBA and want to learn in a very compact way the essential things about performance tuning & troubleshooting SQL Server installations? In our new free 6 month long SQLpassion Performance Tuning Training Plan we give you week by week via email all the essential knowledge you need to know about …
Announcing the SQLpassion Performance Tuning Training Plan + read more
