There are some misconceptions around FillFactor, let’s explore what the setting does or doesn’t do I love SQL Server internals, I do and I just said it. Why? because thanks to all…
Tag: Non Clustered Index
Here is your index, now what?
This 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…
Not the typical story about key lookups
Query plans are very useful to tune queries, but some operations are usually avoided or blamed for performance problems when not always are the culprit, let me show you one of those…
In-Memory NonClustered Indexes, much cooler than disk based
The new In-Memory engine is now available on every edition of SQL Server, including Express, so there is no excuse to start exploring this amazing feature Last week Microsoft has done it. The…