SQL Server Quickie #39 – Semi Joins
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
Files and File Groups in SQL Server
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 …
Data Pages – the Foundation of SQL Server
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 …
Writing a book on Service Broker – a wise decision?
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
Restarting SQL Server – always a good idea?
I see it often in the field – sometimes people regularly restart SQL Server! We all hopefully agree that a regular restart of SQL Server isn’t really a good idea. But in today’s blog post I want to dig a little more into the details what the side-effects are when you restart SQL Server on …
