This week’s post I’ll talk about two new features that don’t seem to get on well. Let’s make them behave and work together as a team Among the overwhelming amount of new…
T-SQL Tuesday #80 – SQL Server 2016, using the Query Store for READ-ONLY databases
The new Query Store is one of the most exciting features coming with SQL Server 2016, but unfortunately comes with some limitations. Learn how we can overcome one of those This…
SQL Server 2016 Query Store, User Data or Metadata?
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…
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!…