SEO (search engine optimization) is a broad general term; there are many forms of search engines besides web searching and Google. Are we talking about a web search engine or...

Like I mentioned above, an index on the DELETE's WHERE clause predicate is...

Talib123 (9/27/2016)

---

Hi All,

I'm a production DBA and have been for a good while.

I can query, join filters but how do I get my T-sql skills to a developer\Report writer...

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.