Gary Varga (3/14/2016)

---

Eric M Russell (3/14/2016)

---

I use the term "BlackOps deployment" referring to those scenarios where IT performs an undocumented operation in production without going through he offical change control...

For years, folks have been using Linux servers as a VM host for running instances of Windows / SQL Server. At least for these customers, Windows is an uncessary OS...

.. You wish to temporarily disable all foreign key constraints on the table since this is an archive database and you orphaned records are acceptable for this one load only...

On medium powered hardware, SQL Server is perfectly capable of running non-covering queries against TB sized tables with billions of rows within a reasonable amount of time (ex: less than...

Jeff Moden (3/14/2016)

---

As Tom...

I use the term "BlackOps deployment" referring to those scenarios where IT performs an undocumented operation in production without going through he offical change control process. Sometimes it may be...

From the perspective of a Business Intelligence professional, there isn't that much difference between a Microsoft SELECT statement and an Oracle SELECT statement. Also, it sounds like you would coming...

Steve Jones - SSC Editor (3/9/2016)

---

Eric M Russell (3/9/2016)

---

It sounds similar to Microsoft Lync / Skype. It's useful for those situations where you need a quick ad-hoc group conversation between...

It sounds similar to Microsoft Lync / Skype. It's useful for those situations where you need a quick ad-hoc group conversation between team members. A lot of useful information can...

As you've already learned the hard way, deleting 600 GB of data is even more time consuming that selecting it 30x over, and yes it's transaction logging that's eating most...

I'm glad to hear that SQL Server 2016 will now support non-clustered indexes, primary keys, and foreign keys on Clustered ColumnStore tables.

adam.hoelscher (3/7/2016)

---

I work in the Healthcare and Group Benefits Consulting field in the United States. Just FYI for anybody reading: many employers conduct what are called "Dependent Eligibility Audits". These...

At least we have a choice. What gets me is when folks take the choice that costs them more money for basically the same level of service, and then they...

One of my ongoing projects is maintaining a PowerShell script to automate the A - Z installation of SQL Server on freshly provisioned virtual machine environments. It first does a...

If you are certain there is a 1-1 relationship between these columns, meaning they are all essentially attributes of one entity and not stand alone entities, then I'd lean in...