Strange, maybe it has to do with the internet firewall on my end; trying to block me...

null

Funny, SQLServerCentral won't let me say: "D R O P TABLE" (without the spaces)

So we're talking about self tuning database servers?

Perhaps:

Indexes that are auto-created based on data access pattterns like statistics.

Deployments that will auto-rollback in the event of an error, without creating...

Grant Fritchey (9/27/2016)

---

Eric M Russell (9/27/2016)

---

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

PiMané (9/28/2016)

---

Eric M Russell (9/28/2016)

---

Data compression is mostly about optimizing storage. Page Compression will yield approximately 70% compression in tables and indexes. By reducing the number of page reads and...

With the default read committed isolation level, readers can block writers and...

Yes, relocating to another city or state is a pain in the arse, and it's expensive, especially if you have to sell a house. I'd consider changing jobs within the...

Data compression is mostly about optimizing storage. Page Compression will yield approximately 70% compression in tables and indexes. By reducing the number of page reads and page buffers, it can...

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