Yes, and it wasn't as disastrous as i thought it would be. I always thought different tables in a single join statement was a bad thing. Query plan didn't look...

On thing that I did notice was that these "rogue" backups were bulk-logged, where the regular daily backups are full recovery model. I need to figure that out for sure.

I guess the most important question is: does sql ever backup a database without being told to by the user? If so, it's news to me.

These particular backups are by the sa login.
It looks like the daily backups use NT AUTHORITY\SYSTEM. Strange. 
They don't have any maintenance plans, so im not sure how those...

There were some parenthsis...

This is a great start for our documentation efforts!

I did find that there was an extra parenthesis in the code for the proc dbo.ScavengeDataDictionaryFields. Once I took it out it...

Thanks, folks.

Kraig, I was doing a straight rowcount of a 4 million row table, so that would explain the perf difference. The code I saw used SUM(1) for counts almost...

@ninja's_RGR'us

That is wonderful!

I'm not sure I'm following your expected results.

According to the data, type 2 (chicken), was liked by 5 animals, but 3 are filtered out:

Woofer is deleted in Animal table.

Fido and...

our ops team is using SQL Sentry, so they have been able to provide us the deadlocking.

We are also getting deadlock while trying to add subscribers. I can't figure it out.

We caught some of the blockers, listed below:

sys.slp_MSRepl_changesubstatus

sys.sp_MSLockMatchID

the command called in the query that...

as a (relative) beginner, it helped illustrate the concept for me much better than BOL does. it also inspired me to do some side by side runs on our data...

I'm looking into this myself. in my case, the max_worker_threads has been set to 400 on our server in the syssubsystems table, but we're still getting an error saying we've...