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

Jun
22
2016

Update Statistics Misconception

On the 15th of June I made my first presentation at my local user group, and I have to say that was a nice experience. The presentation is about SQL Server statistics and at certain…

Continue Reading »

Jun
16
2016

Database design matters, seriously

This might sound pretty obvious, but really, database design matters. And all those rules and best practices about database…

Continue Reading »

May
31
2016

Extended Events File Target Reader

It’s been some time since I started with my first SQL-G Hack, and I think those are precisely the kind of posts you might want to find when searching…

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 »

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 »

Apr
15
2016

Back To Basics, Lock Escalation in SQL Server

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…

Continue Reading »

Mar
31
2016

Index Creation VS SSMS Query

Tonight, Ladies and Gentlemen, we have one of the most expected fights in SQL Server!! Yeeeeeah!! Booooohhhh!!! (People cheering and booing) Hm, now seriously, I just read a comment in a blog…

Continue Reading »

Mar
14
2016

The Mysterious Case of the Missing Default Value

*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…

Continue Reading »