If the delta for number of bytes written has changed, then you can assume that logs need to be shipped.

Also, the 2nd query will look at last update date...

Why are you wanting start a new development project using Clinton era technology like classic ASP ?

robert.sterbal 56890 (9/28/2016)

---

I wonder if PASS would consider using the service:

MP3 To Text Transcription

http://www.transcriptionstar.com/mp3-transcription/mp3-to-text.html

for the 24 hours of PASS recordings.

Do you have any actual experience with the service?

My real...

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