Grant Fritchey (9/27/2016)

---

Rich Mechaber (9/27/2016)

---

But. If I worked for Grant, I'd be terrified of telling him anything in the way of bad news. Who's gonna volunteer to inform...

Especially for a flattened table, using DATA_COMPRESSION = PAGE option on a conventional row store clustered index table should result in 50% - 70% compression, which does translate into fewer...

200k rows isn't very large to begin with, and a medium sized server can easily table scan that within a few seconds with no indexing. But since it's for archival...

DevOps works when it's intentional; like when IT staff have DevOps as part of their official job description, are separate from the development team and have their own manager. DevOps...

Steven.Grzybowski (9/26/2016)

---

A locked box.

Inside that locked box is medication. Lots and lots of medication. My regularly prescribed daily meds, every OTC NSAID you can think of,...

ScottPletcher (9/26/2016)

---

Eric M Russell (9/26/2016)

---

ScottPletcher (9/23/2016)

---

Not necessarily. If the best clustered indexes are...

ScottPletcher (9/23/2016)

---

Not necessarily. If the best clustered indexes are not already in place,...

In all fairness to the DBA, this situation might be a reacton to the IT environment; for example office politics, the incentive program, or micromanagement on the part of upper...

Yes, what can't be measured cannot be managed.

Brandie Tarvin (9/23/2016)

---

Eric M Russell (9/23/2016)

---

Brandie Tarvin (9/22/2016)

---

Eric M Russell (9/16/2016)

---

If this is something like a data warehouse, where you have very large tables that are sourced for reporting purposes...

Brandie Tarvin (9/22/2016)

---

Eric M Russell (9/16/2016)

---

If this is something like a data warehouse, where you have very large tables that are sourced for reporting purposes from other transactional databases, then...

Revenant (9/23/2016)

---

...

I was responding to 'from SQL2005 to SQL2008' - the latter one is on extended support. So I wander why would anyone go that route. Maybe they got some...

Applying what you learn in the context of an actual project helps round it out and commit it to memory. Often times an employer will send staff to $,$$$ training,...

webrunner (9/23/2016)

---

Eric M Russell (9/23/2016)

---

Yet Another DBA (9/23/2016)

---

It is narrow-AI and not general-AI (which is what WATSON is trying to be).

If we have problems with developers running feral in...

I think most DBAs would be more excited about RegEx integration than R. :doze: