SELECT *
FROM Posts
WHERE Date_Posted = 'mayo 2016'

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 »