SELECT *
FROM Posts
WHERE Tags IN ('Storage Engine')

Apr
26
2017

Successful Anti-Patterns, Using Deprecated Data types

From time to time it’s good to remind people about the…

Continue Reading »

Mar
29
2017

Spring cleanup, LOB considerations

So spring time is here and probably you feel like cleaning up your databases, and that’s good. In previous posts…

Continue Reading »

Mar
2
2017

Benchmarking storage using Diskspd.exe

Last week I’ve been testing some new storage at work…

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 »

Nov
3
2016

Database Design Matters, Real World Scenario

Disclaimer: This is how I solved a particular problem after analyzing and understanding my data….

Continue Reading »

Oct
19
2016

Successful Anti-Patterns, Storage Requirements

One of the things you realize with experience is…

Continue Reading »

Sep
21
2016

Database Design Matters, choosing the Clustering Key

There has been a permanent debate about which is the right clustering key for our tables since the…

Continue Reading »

May
10
2016

Successful Anti-Patterns, Key Lookup VS RID Lookup

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…

Continue Reading »

Apr
26
2016

Shrinking large half-empty MDF

Once again I’ve found my inspiration browsing linkedin SQL Server groups. Love it! First I have to say I’m a big fan of DBCC SHRINK, I use it all the time… NO, that was a bad…

Continue Reading »

Mar
24
2016

SQL Server 2016 COMPRESS and DECOMPRESS performance

One of the most exciting things for me in this new version of SQL Server is inclusion of native gzip compression into the, I guess, storage engine functionalities. I know you can implement your own CLR version of…

Continue Reading »