Where I work now, we have a dedicated DevOps team who performs functions like application configuration and support, deployments, automation tooling, etc....

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

---

Eric M Russell (9/27/2016)

---

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

Are you deleting one row or a range or rows?

Also, is the selectivity of the delete operation covered by an index?

For example, if you DELETE FROM TABLEA WHERE...

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