GilaMonster (1/11/2017)

---

Eric M Russell (1/11/2017)

---

No doubt someone at this moment is trying...

Steve Jones - SSC Editor (1/11/2017)

---

jasona.work (1/11/2017)

---

Coming at this from more a production DBA and less a developer DBA point-of-view, I'm rather ambivalent about SQL on Linux. To a...

How big is your SSD compared to the size of your database?

Now, does SSMS or Toad work on Linux?

No doubt someone at this moment is trying to install SQL Server...

The findings of studies like this can be skewed, because it's limited to a biased population. For example, they are not surveying all mothers who gave birth, but rather only...

First, definitely don't store pre-formatted data (ex: "$1200.50" or "01/11/2017 09:12AM") in the table as VARCHAR columns. That's a bad idea because it obstructs your ability to sum, evaluate, and...

.. Certainly I expect lots of (free) Express editions installed by developers, which will allow them to gain experience, and perhaps be more comfortable in the future with SQL Server...

This U-SQL is the most exciting new language to come on the scene since Esperanto.

ScottPletcher (1/10/2017)

---

I specialize in tuning, particularly index tuning, and I tend strongly toward the larger, shared index rather than separate indexes. Be aware that if the index needs scanned,...

When I look in MSDN subscriber downloads, I see x86 and x64 versions for SQL Server 2014. However, I don't see it for 2016.

What are the specs (hardware and OS)...

I believe there are two trends going on here that work in favor of SQL Server. One is simply that SQL Server 2014 and 2016 introduced or matured a number...

Phil,

The name of the this article "Keeping up to, and down with, Date"; I get that it's a pun making reference to the mathematician, relational database pioneer, and author Christopher...

The other day while cleaning out the garage, I stumbled across a box full of old IT books. One was a late 1980s era edition of "Oh! PASCAL!" by Doug...

For what it's worth, a few days back, I posted a script to query details about objects are allocated in TEMPDB, including the SPID, application, procedure name, and SQL statement...