As you might know, a few weeks ago Microsoft released the first public CTP version of SQL Server that runs directly on Linux! Therefore it was time for me to cross the bridge and install my first ever Linux installation so that I could play with SQL Server on it. In this blog post I …
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
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.
