Just to play the devil's avocado:

- XML is a first-class citizen in SQL Server and as far as validation goes that's what DTDs are for. Right?

- I'm not sure what...

If the log reader agent is running, and changes are being picked up and sent out, and the sys.databases log_reuse_wait_desc for the publication database is showing "replication", then I'm not...

I may have seen the same thing.

Specifically I set up transactional replication on tables that see some usage, sent out a large batch update during the day (I don't leave...

A checkpoint just means it's writing to disk. It doesn't mean what you appear to think it means. They happen all the time, it's user configurable...

No. Unless you had a script that overwrote those database files as the server was coming up, or something unbelievable like that.

No, so...

Step 1. Install sp_WhoIsActive for next time

Step 2. Profit

I have so much fury for Prometric. They're accountable to nobody.

I recently cancelled a test. They managed to charge me the $32 refund fee immediately. Then it took them...

jcrawf02 (4/1/2014)

---

Personal facts: I am white, male, not quite 40, and I went to those discussions because I felt they were important and wanted to be part of that discussion...

That has worked for me with some managers that appreciate what I'm doing.

In...

I haven't seen it, but:

- How long does a backup take?

- How often is the job being sent to start a backup?

- Where is the backup going to?

I feel like...

Never mind I think I get it.

I feel like there's quite a large disconnect between the intentions of the author, how the article was read, the comments, and then the...

I was, ummm,...

Frankly, the date aside, I think it should have done this. SQLCLR is a massive pain in the butt to write, compile, then distribute the DLLs, then load onto a...

REDRUM!

I don't know but when I read it I was shocked. I would certainly like access to the raw data to confirm it for myself because I get the feeling...