I'm no longer a real DBA now. But, I started working in IT in development. I probably would have kept doing that if I hadn't moved into the DBA role....

There's not going to be a giant performance difference between CHAR(2) and VARCHAR(2) when it comes to NULL values. When the value is NULL, there is no length stored with...

First up, there are specific wait statistics assigned to query store. When you query sys.dm_os_wait_stats, if you are experiencing issues with Query Store, that's where you'll see the evidence of...

I expanded this into a full blog post. Comes out a little after 10. Yes, DBCC TIMEWARP is mentioned, but no, it's not the "Run Really Fast" button.

OK guys. I think it's way past time. We need to just unveil the magic "Run Really Fast" button that we know about and are hiding from the rest of...

I'm not sure about others, but I think this may be a tough nut to crack. 

First of all, I wouldn't put any kind of process inside your existing...