A backup is a page level copy of the original, so there is no need to perform another re-index or re-stat after restoring.

Also, if your reporting database is static after...

For about the 3rd time in the past week... sp_MsForEachTable to the rescue.

exec sp_MsForEachTable

'

if ''?'' like ''ntEventLog%''

begin;

print ''truncating.. ?'';

truncate table ?;

end;

';

robert.sterbal 56890 (9/28/2016)

---

My two practical test are podcast transcription and photo identification.

When this gets done affordably, we will have reached a new level of technology.

I'm more than happy to follow...

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