SELECT * FROM Posts WHERE Tags IN ('SQL Server')
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…
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…
This might sound pretty obvious, but really, database design matters. And all those rules and best practices about database…
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…
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…
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…
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…
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…
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…
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…