I don't want to overwrite the msdb db.

I want to restore msdb as a user db called <msdb_oldor whatever>.

Then I want to insert "missing" data in a couple of the...

Another 0.02 cents (not a typeau).

I don't have SSD in prod nor do I have tested it.

The fact is afaik MS never spoke about disk speed in their fragmentation recommendations.

The...

All the reasons not to use nolock (readuncommited)

http://sqlblog.com/blogs/andrew_kelly/archive/2009/04/10/how-dirty-are-your-reads.aspx

I'd still like to see the actual execution plan (especially when slow).

When's the last time you reindexed / updated the stats?

Do you filter...

Check if the user has access to master.

It's most likely a monitoring app or service that doesn't specify the 3rd party db in the connection string and then does use...

GSquared (9/6/2011)

---

It's almost certainly either a homework/test question, or an interview question, with a slight possibility of being a "hey, I wonder" type curiosity question.

Either way, every DBA or future...

Is the jobid indexes?

Do you have triggers?

Do you have a ton of indexes on that table?

Do you have lots of fks (or any of them NOT indexed correctly)?

Waitfor in the...

Way more than you should ever need.

Why do you ask / need to know?

I just hit report on your post so Steve will take a look at it.

No sure what else you could have done except e-mailing Steve directly.

I use reporting services. Never had a report / dashboard I couldn't do.

Like any tools it has its good and bad. I've never used anything other than...

Hire someone. You need to analize the needs and actually fulfill them.

I've never seen on out of the box do that 100%, assuming one exists for your boss.

What do you need exactly? This question is too vague to answer.

Ask what changed to the san / network admin.

Things just don't slow down on their own.

GilaMonster (9/2/2011)

---

Out of curiosity, what is US...

Yup, nice place to...

That was the calm before the storm (Irene).

That was our 2nd storm of the century here in 6 months.

Nice year 2k11 😛