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
In todays blog posting I want to talk about a very cool enhancement in SQL Server 2014: you are now finally able to throttle queries regarding their needed IOPS! Resource Governor was introduced back in SQL Server 2008, but the feature set was somehow limited: you were just able to limit CPU times (which is …
How to throttle your Storage with Resource Governor in SQL Server 2014 + read more
In this blog posting I want to talk a little bit in more detail why you should avoid Auto Growth operations on the Transaction Log. In my various consulting engagements I see a lot of SQL Server databases, that are running with the default file configuration for the initial size and Auto Growth settings for …
Why Transaction Log Auto Growths are degrading your performance + read more
In todays blog posting I want to talk a little bit about Online Index Rebuild operations, and how they are improved in SQL Server 2014. As you know, SQL Server 2005 first introduced Online Index Rebuild operations. But these online operations are not really online operations, because SQL Server has to acquire a Shared Table …
How SQL Server 2014 improves Online Operations that aren’t Online Operations + 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.
