I would consider finding a backup of msdb from before it got deleted and restore it.

My laptop is on Windows 7 too. I wouldn't use it on real servers, but for testing, it should be fine.

I didn't experience any problems with the queries either. I ran it on my laptop with 8 CPU and 16 GB of RAM (which was running 3 other SQL instances...

Also, how did you free the cache? There are many ways to free caches, each with different effect.

Your simple query does not include the new table. Is that the right...

That's not a bug. That's a side effect of an improperly configured database.

Yes, good point. Only affects after triggers, not instead of triggers.

Are nested triggers disabled?

Select value_in_use

from sys.configurations

where name = 'nested triggers';

Instead of triggers are executed before an after trigger, and if nesting is disabled, the insert from the instead of trigger...

Quote of the day! 🙂

Don't ever delete files manually. Sounds like you hit a case of a deferred drop operation. When there is a lot to be deleted or truncated, the actual delete may...

Absolutely. It's key to look at the wait columns. Mainly, what it is waiting on and how long it has been waiting. The wait duration column will tell you how...

Don't shrink the log!!!

Backups do not shrink the log (unless you have committed the unforgivable sin of enabling auto-shrink)!

Don't free the various caches either. They are unrelated and will cause...

Is object xxx an indexed view on both the publisher and the subscriber? The NOEXPAND hint applies to only indexed view and if you're not replicating indexes, then the view...

Just poll sys.dm_exec_requests for the status, blocked by, and wait type columns.

As an example, here is a query I wrote to raise an alert in the application event log (then...

Tracer tokens only work with transactional replication.

This query is also for transactional replication, but it wouldn't take much to change it to the merge agent instead of the distribution agent:

http://www.sqlsoldier.com/wp/sqlserver/measuringtransactionalreplicationlatencywithouttracertokens

If you have a two-way trust between domains, you don't need to use certificates. You have to make sure that each SQL Server service account is a domain account and...