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

null

Also, let's not forget the HeartBleed vulnerability discovered a few years back in OpenSSL.

http://www.pcworld.com/article/2141740/is-open-source-to-blame-for-the-heartbleed-bug.html

Open Source means that the public can review the code to verify that the developers are not...

Half a GB of clickstream data per NetFlix user every day should raise some eyebrows. When I read about these PB and EB scale Big Data projects, I think about...