Boy it's been awhile. I think this was some system account for remote linked server type activity. I remember it being a little of a security hole.

There is an mdf in there (didn't look for the ldf). You can attach these to your SQL Server.

Is this through a maintenance plan? Might be hosed up. Check the schedules and be sure everything is enabled.

The EM count comes from teh index, usually the indexid = 1, so I'm not surprised there. I'd drop and recreate the index if you can. If the above doesn't...

Haven't run into this, but that sounds like it might be a bug.

Which checklist? I run this and compare to the last time I ran it.

I don't think so. I believe that stored procedure cache, and perahps internal structures (locks, connections, etc.) can consume memory that is not reported in the buffer cache.

I believe that WITH DROP_EXISTING will minimize the nonclustered rebuilds. It's possible if you just drop and then recreate the index for nonclustered ones to be moved more than once.

I'm assuming this is some sort of parsing routine, so I won't ask why you care. My guess is that + and - are not just characters, but operators as...

While I don't think it's a big deal, it is a possible security risk. Just one more attack vector that is open. You might want to be sure that their...

Booksonline has some basic information. The best place I've seen on the web is http://www.google.com/microsoft

Not that I'm aware of. AFAIK, a restore should put everything back as expected. If it was a different server default, perhaps it changed. An interesting thing to look at.

I don't think there is any way to change this. You could have them script changes and then run them through someone who does own the table.

You can do what I do. I have a script that checks the flat files as well as the jobs and generates an HTML file that is stored on the...

A few things to consider. Allocations are in extents, so you will always use space according in extent lengths. Similar for pages.

Indexes are separate (nonclustered) and have some small overhead,...