A few days ago I received my attendee feedback from the SQLBits 2016 conference, which was held this time in lovely Liverpool. I had done a whole day precon about Locking, Blocking, and Deadlocking and a 1 hour long session about Joins in SQL Server. As easy as ABC? So let’s take a few minutes …
Today I have uploaded SQL Server Quickie #39 to YouTube. This time I’m talking about Semi Joins in SQL Server. Thanks for your time, -Klaus
In today’s blog post I want to talk about a very important topic in SQL Server: how SQL Server handles Files and File Groups. When you create a simple database with a CREATE DATABASE command, SQL Server only creates 2 files for you: A Data File (.mdf) A Transaction Log File (.ldf) The data file …
Pages are the foundation of SQL Server – everything in SQL Server is about pages. When we want to improve the performance of our queries, we try to lower the page reads that SQL Server needs for a specific query. When we talk about indexing in the 2nd month, we find that even index structures …
Last week Brent Ozar published a blog post, where he talked about how choose a successful topic for a weblog. He gave 3 different examples of success and even failure: Jonathan Kehayias, who has established his name with his famous Extended Event series Niko Neugebauer, the well-known guy on ColumnStore Indexes Klaus Aschenbrenner, who wrote …
Writing a book on Service Broker – a wise decision? + 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.
