Yup, though you're probably better off using perfmon than task manager for anything other than a casual check.

And before you ask, there's no 'normal' value. It's completely dependant on your...

Since you're not planning to restore the logs (why?) no need. Just...

Who knows? That's just saying how much CPU time that spid has used since it started. Without knowing what it's...

I wish I got this kind of punishment. This is dead simple and very quick.

You haven't...

Depends what the server's doing. That's kinda like asking "How long is a piece of...

Bummer. Hope nothing breaks.

This is the first...

I'm not going to ask too much. I'd love a machine with a user interface somewhere between the one in Minority Report and the one in Quantum of Solace.

Heap, no. It doesn't have the b-tree structure, it's not an index.

Don't forget spatial indexes on...

Plans are there. Fairly easy to identify too, the objectid in...

My colleague's around that age and he runs rings around me...

A hardcoded password is a bad idea, for this reason and others.

You can put the password in the app.config file (encrypted) and have it different on dev and prod. Preferably...

Please don't repost a question that people are working on. It just leads to redundant replies and means people will waste their time answering questions that have already been answered.

Please...

Your original question asked how to copy a database.

Do you need to copy an entire database or a single table within a database?

If the latter, is there a linked...

True, though that's a hellishly painful way to get execution plans.

I need to check and see if...

You don't. 🙁

Take the contents of the function, put in management studio, declare variables in place...