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…
Month: May 2016
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…