SELECT * FROM Posts WHERE Tags IN ('SQL Server Internals')
Following a conversation with my junior DBA, I decided to show you what happens when we disable indexes and in particular when we disable the clustered index for a…
When it comes to technical subjects like databases, we must always look for proven solutions and best practices, which usually take us from A to B in the most efficient way. Usually. But what happens…
Today at work we’ve had a very common request, no big deal, just a couple of UPDATE which affect tens of thousands of rows in a couple of tables independently. I can say I’ve been there, done that…
*First published @ www.SQLServerCentral.com (2015/12/01) Once upon a time, there was a DBA… yeah right! As probably like many SQL DBA’s, little by little I’m getting more curious about how SQL Server works internally. To…
The other day I saw a thread on linkedin groups that was titled ‘Using Parameters in a Query is Killing Performance’, where the author…
One of the basic (and well used during interviews) questions about SQL Server internals is how you call a table without a clustered index, and that in SQL Server is called a HEAP….
Compression in SQL Server has been around for a while now, to be precise since SQL Server 2008, and comes in two different (complementary) flavors, ROW and PAGE compression. Unfortunately it’s only available in the Enterprise Edition (and Developer…
The last weekend of October is a common date for the daylight savings (or summer time) to get to its end in the north hemisphere. According to Wikipedia: Daylight saving time (DST) or…
*First published @ Steve Stedman’s blog (2015/06/07) The seventh week of ten in the Database Corruption Challenge went well. There were a few new participants, and many of those who have competed week over week. The first to submit a correct answer this week was Raul…
*First published @ Steve Stedman’s blog (2015/05/27) If you are looking for more info on the corrupt database with Week 6 of the Database Corruption Challenge, you can take a look at the original post. Week 6 was won by Raul Gonzalez who submitted his…