SELECT *
FROM Posts
WHERE Tags IN ('Performance Tuning')

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
22
2017

Not the typical story about key lookups

I understand that if you want to keep up with technology (or at least try), you…

Continue Reading »

Sep
30
2016

Multi-column statistics are back in SQL Server 2016

Don’t get me wrong, they’ve always been there, but somehow someone forgot about them and weren’t used. Since last…

Continue Reading »

Jul
6
2016

SQL Server 2016 Query Store, User Data or Metadata?

It’s been a month since the SQL Server community has their new toy, SQL Server 2016, which to my surprise and considering not everyone has yet adopted SQL 2014, it’s absolutely packed with new…

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 »