Many of us have heard of several rules of thumbs how to use a SQL Server correctly. To do this, to avoid that. Over the years, I have started to proof these given rules. As I expected, there was a big "it depends!" in most of them.
My mantra is that I will only belive in facts I can measure.
As some of you may know, I'm originally a developer. And one of my primary patterns is to automate as many activities as possible when analyzing and optimizing a complex SQL Server environment. And this quest allowed me to develop a lot of interesting tools.
And, on my journey, I found many new facts (and, of course, rules) I have never expected.
My first thought to share my experiences was to post them in a blog. But then I realized that I need a media to improve each of the tests and articles over time. Using a blog could confuse readers when I often update a published post or post frequently additional insights into a given topic. I want to deliver a smooth reading & learning experience to get the most out of the facts.
In my experience, a solid knowledge of the SQL Server internals combined with real experience makes sense for any developer and, of course, administrator.
I like to call it SQLbility.
And this website is intended to be a shortcut not to have to make all the experiences and mistakes by yourself.
I want to help you to increase your SQLbility!
First at all, there are many myths and rules about the correct usage of indexes. So, we will take a very close look at many of them.
And to make things even more complicated, we also look at query plans.
Finally, you will be faced with really nitty-gritty details of the SQL Server engine.
© 2019 Sascha Lorenz - All rights reserved.