SELECT *
FROM Posts
WHERE Tags IN ('SQL Server Internals')

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 »

Feb
9
2017

Statistics and Data types, What can go wrong?

One of the most interesting things in SQL Server from my point of view are Statistics and how the optimizer interprets them to produce optimal query plans. But today I want to write about something…

Continue Reading »

Nov
30
2016

In-Memory logging, much cooler than disk based

Last week we started exploring some of the cool features that the new In-Memory engine (code name Hekaton) has brought into…

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 »

Sep
6
2016

Database design Matters, choosing the right data type

This is not the first time I write about best practices or how a good design can…

Continue Reading »

May
25
2016

TRUNCATE TABLE misconceptions

TRUNCATE TABLE in SQL Server is well known for what it does as feature, but how it actually works is easily misunderstood, and for long time, the same…

Continue Reading »

May
18
2016

Index fun, disabling the Clustered Index

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…

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 »