why cluster on VendorServiceID? You can have a primary key that's non-clustered.

Use the clustered index for one of the dates since they're often queries in ranges.

I don't think that <...

Search for cross tab queries.

There isn't an easy way to do this. You can do with with self joins, i.e.

select a.colA + ',' + b.colA from tableA a inner join...

Why would you need to know how many records in every table have been changed? That seems strange. I could see a few of them, but wouldn't lots of tables...

Keep posting here, and we'll try to help.

Honestly, I'd recommend you beg for some $$ to pick up one SQL 2005 book, any of the admin books (check half.com) and...

Also, is the code always slow? If you run it 10 times in the db and in tempdb, is it always slower in tempdb?

If the code is the same, why not deploy it to each database and call the code directly without worrying about dynamic SQL?

Having 40 copies of stored procedures in 40...

Are you moving all data from this table? You could move the clustered index (rebuild on the new file) instead. Not sure if the image data moves, but I would...

that is strange. Does it compile without the db name reference? Shouldn't matter, but not sure why this is a problem.

Some good advice, and there are a few articles on this site (search naming conventions).

I try to get things to group, since that's how I use them. So everything with...

syslogins is a quick check for the sysadmin column or some of the other roles.

If you want a procedure, try sp_helpsrvrolemember (http://msdn.microsoft.com/en-us/library/aa933412(SQL.80).aspx)

I think that you wouldn't necessarily put this on your resume if you'd been working with the product at home, but you can mention it in the interview. Or you...

I have a reciprocating saw, though I haven't used it there. Typically I've found doing the work myself means that I can afford to mess up completely once and still...

Not sure, but I'll ask around. You can ask for %complete in this command using the stats option. Not sure that this is what dm_exec shows.

Have you checked the log...

This is really a lot of questions for one post. I'd split them up.

I'm not sure about knowing which objects from which databases are in tempdb, but the size you...

First, I wouldn't use R0. Backups are important.

Second, if you run a smaller backup, say 1GB, is it a similar rate of things being written?