One of the newest features for SQL Server is the Query Store, let’s explore it to know a bit more about it It’s been a month since the SQL Server community has their…
Tag: SQL Server
Update Statistics Misconception
Having statistics up to date is important to get good query plans, but sometimes how to get it might be misunderstood On the 15th of June I made my first presentation at my…
Database design matters, seriously
All those rules and best practices about database design exist for a reason. Today I want to show you something very simple for you to see how a good design might improve…
Extended Events File Target Reader
Getting useful information from Extended Event files is sometimes very tedious as you have to use XML queries and even PIVOT, what can be a better plan? It’s been some time since I…
TRUNCATE TABLE misconceptions
There is a number misconceptions around TRUNCATE TABLE which have been around for too long that people take them as the real truth, let’s debunk some of those TRUNCATE TABLE in SQL Server…
Index fun, disabling the Clustered Index
Disabling an index is always fun, but disabling the clustered index is even funnier, but probably not for your users, let me show you what can happen. Following a conversation with my junior…
Successful Anti-Patterns, Key Lookup VS RID Lookup
This post wants to show some performance improvements we may have by doing things the way we’ve been told not to When it comes to technical subjects like databases, we must always look…
Shrinking large half-empty MDF
Shrinking your database is not a best practice (sometimes can be acceptable) but it might be trickier than you expect Once again I’ve found my inspiration browsing linkedin SQL Server groups. Love it!…
Back To Basics, Lock Escalation in SQL Server
Sometimes something innocuous can take our application down, that’s why it’s important to get back to the basics Today at work we’ve had a very common request, no big deal, just a couple…
Index Creation VS SSMS Query
Is it true that creating the index is quicker than running the query you needed it for? Let me show you the answer Tonight, Ladies and Gentlemen, we have one of the…