I'm not sure if 21st century data is analogous to 20th century oil. Oil is a scarce commodity that is expended when it's used and can't be replicated. However, data...

thisisfutile (9/24/2014)

---

Eric M Russell (9/24/2014)

---

The only time I've ever a motherboard to go bad is when I was working outside under the patio umbrella, and my then five year old...

The only time I've ever a motherboard to go bad is when I was working outside under the patio umbrella, and my then five year old daughtert though it would...

Miles Neale (9/19/2014)

---

Truth be told I kind of like the preproduction code...

Updatable ColumnStore indexes, in-memory OLTP tables, and Delayed Durability are game changing features for which the SQL Server engineering team should be applauded. However, I still think Microsoft marketing department...

I believe that how Microsoft numbers their version releases should be carefully considered by the marketing department from several different angles. For example, SQL Server 2014 generates a lot of...

Steve Jones - SSC Editor (9/11/2014)

---

Jim P. (9/11/2014)

---

Another thing that you should do is create a portfolio of your accomplishments. That makes it easier to interview. The first section is...

Doctor Who 2 (9/10/2014)

---

...

The first and biggest surprise to me, once I joined the ranks of the unemployed, was when I discovered just how long it takes for anything at...

It is surprising to see someone put PowerShell at the top of the list; maybe because the website is geared toward Windows Server administrators, and Microsoft is phasing out VBScript...

mai.quangvinh (9/9/2014)

---

My colleague who is a dba help me investigate the issue, she found that the destination table has primary key which is a composite index including 3 column and...

Ideally, you don't want to shrink your transaction log, because it's more efficient to re-use the same log. However, 100 GB of logging on a 6 GB table (or 6...

Gotta love the title "Chief Happiness Officer". 🙂

If you are the designated person who is expected to stand in for the role of organizational president, even if it's only required on rare occasions, then you should have...

I didn't build most of the software running this site, but I do think that SQLServerCentral as a total entity is the thing I'm most proud of. I'm not sure...

Using T-SQL to parse EDI records is probably not the best way to accomplish whatever it is you're doing. You would get more useful advice posting this question in a...