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 …
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
Today I have uploaded the 10th SQL Server Quickie to YouTube. This time I’m talking about Forwarding Records on heap tables. Thanks for watching! -Klaus
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
In todays blog posting I want to talk about myths & misconceptions about the various Transaction Isolation Levels that exists in SQL Server. I mainly want to talk about the following topics: Transaction Isolation Levels – What? NOLOCK never blocks!? Read Committed doesn’t holds locks!? Key Range Locks are specific to Serializable!? So let’s get …
Myths and Misconceptions about Transaction Isolation Levels + read more
Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.
