SQLServer

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

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 …

DELETE operations on tables + read more

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

You know the problem: the “Estimated Number of Rows” in an operator in the Execution Plan is 42, but you know that 42 isn’t the correct answer to this query. You have also heard some time ago that SQL Server uses statistics to make that estimation. But how can you interpret these statistics to understand …

Inside the Statistics Histogram & Density Vector + read more