Last week Microsoft made a historic announcement regarding SQL Server: with the introduction of the Service Pack 1 the Standard Edition of SQL Server offers you the same features as the Enterprise Edition. You don’t trust me? Just look here. This changes the whole game in the market for relational databases and is mostly a …
SQL Server 2016 SP1 Standard Edition = Enterprise Edition!? + read more
A few weeks ago one of my blog readers asked in a comment if it is a good idea to set the Recovery Model of the model database to SIMPLE, and if there are any downsides of that approach. I can’t emphasise it enough, but using the Recovery Model SIMPLE for a OLTP workload (which …
Why the Recovery Model SIMPLE is a really bad idea + read more
Today I have published SQL Server Quickie #41 on YouTube. This time I’m talking about the Recovery Mode SIMPLE in SQL Server. Thanks for your time, -Klaus
Today I want to talk about another very interesting topic in SQL Server: disabling Row and Page Level Locks in SQL Server. Every time that you rebuild an Index in SQL Server, you can use the ALLOW_ROW_LOCKS and ALLOW_PAGE_LOCKS options to specify that SQL Server should acquire Row and Page Level Locks when accessing your …
Disabling ROW and PAGE Level Locks in SQL Server + read more
Years ago I blogged about Latches and why they are needed by SQL Server. In today’s blog post I want to concentrate a little bit more on the Buffer Latches (BUF), and how they are used by SQL Server during Index Seek Operations. Here you will learn a concept called Latch Coupling. Index Seek Operations …
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.
