congratulations to the winner!

Steve Jones - SSC Editor (5/30/2016)

---

Terje Hermanseter (5/26/2016)

---

I'm not sure I...

I'm not sure I fully understand the "choose the clustering key...

After many fruitless discussions with the company owner to change this situation, I sat him down at this receptionists computer, logged in as her, got him to open ISQL/W and...

Everything in this editorial sounded all too familiar..

Our most important systems are running on Sybase. We do test thoroughly every time we are migrating to a new version. (We never upgrade our database servers, we're migrating the...

Steve Jones - SSC Editor (5/12/2016)

---

Terje Hermanseter (5/12/2016)

---

Are there any use cases at all for having differently sized tempdb files? I see only recommendations for using the exact same size...

If one file is significantly larger (or more correctly have a higher write-free-perecent) than the others, that file will receive all the write operations. If that happens you have no...

Are there any use cases at all for having differently sized tempdb files? I see only recommendations for using the exact same size for all the files.

Yet another feature in SQL Server that we haven't used on any of our production servers.

Are there anyone out there that uses this feature frequently? I would imagine ...

Agree, seeing the correct answer to the question, I think the question should have been "In SQL Server 2014, how do I use the vardecimal storage option?".

13.00.2600.00

My company runs a 24/7 business. As a DBA I take down our main DB servers for maintenance every 6th week for about 1 to 1 1/2 hour each time....

PowerShell

DevOps is how we built and deployed software in the 90's. Only then we didn't had a term for it. Later things changed and people started working in silos. That...