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

Feb
9
2018

Here is your index, now what?

s story might sound familiar for most of the DBA’s out in the wild. Our job to keep databases up and running, and sometimes, make them to go faster (I’m not going into what fast mean, just in case). Some other times, we have developers, that want their code to run faster, they seem to…

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
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 »