SELECT *
FROM Posts
WHERE Tags IN ('Non Clustered Index')

Nov
15
2021

FillFactor, the Untold Story

I love SQL Server internals, I do and I just said it. Why? because thanks to all the tools, documentation and community members that share their knowledge, folks like me can understand how a super complex piece of software like…

Continue Reading »

Feb
9
2018

Here is your index, now what?

s story might sound familiar for most of the DBA’s out in the wild. Our job to keep databases up and running, and sometimes, make them to go faster (I’m not going into what fast mean, just in case). Some other times, we have developers, that want their code to run faster, they seem to…

Continue Reading »

Mar
22
2017

Not the typical story about key lookups

I understand that if you want to keep up with technology (or at least try), you…

Continue Reading »

Nov
23
2016

In-Memory NonClustered Indexes, much cooler than disk based

Last week Microsoft has done it. The release of SQL Server 2016 SP1 is a game changer, most of the desired but sometimes prohibitive features from Enterprise Edition are now…

Continue Reading »