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…
Tag: SQL Server Internals
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…
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…
The Mysterious Case of the Missing Default Value
Sometimes things are not exactly how we think they are. Read the story of the missing default value and learn why. *First published @ www.SQLServerCentral.com (2015/12/01) Once upon a time, there was a…
Fast with values slow with variables
There is a big debate why the same query can run fast with hard coded values and slow when using variables, come see there is a reasonable explanation for all this mess. The…
Clustered index row order
How rows are physically stored is well known and sometimes very misunderstood, let me show you something might not be as you expect One of the basic (and well used during interviews) questions…
Row compression, a bit of internals
Compression in SQL Server has been around for a while now, come explore how it works internally Compression in SQL Server has been around for a while now, to be precise since SQL…
Daylight Savings end affects not only you, but your SQL Server too
If you take log backups and you changed from summer time the last Sunday of October, your backup log chain might be broken The last weekend of October is a common date for…
Steve Stedman’s DBCC Challenge, Week-7 Winning Solution
Week 7 of the Database Corruption Challenge (DBCC), winning solution by @SQLDoubleG *First published @ Steve Stedman’s blog (2015/06/07) The seventh week of ten in the Database Corruption Challenge went well. There were a…
Steve Stedman’s DBCC Challenge, Week-6 Winning Solution
Week 6 of the Database Corruption Challenge (DBCC), winning solution by @SQLDoubleG *First published @ Steve Stedman’s blog (2015/05/27) If you are looking for more info on the corrupt database with Week 6…