I think it's you.

If SS2K8 SSMS you can color code your connections so you know which query is connected to which server.

I'm not sure any tool handles the multiple tab...

No, when SQL starts it opens the db and that's it. It doesn't log the activity.

I'd set auto close and check the log periodically. After xx days, detach the...

Maybe I should run this query as a job? kill the user here that uses the most CPU and memory every 5 minutes?

I would agree that killing the most heavily used query is a way to get into trouble. I think what you need to do is identify what the user(s) is...

you might have been connected to that particular database, or it's your default.

Try opening a new query window, connecting to your instance, choosing master as a specific db.

If you did not install SQL Server as a cluster node, you cannot make it a cluster node. You'll have to reinstall it, or install a named instance as a...

I enjoyed Loveland tues, not sure we'll go tomorrow. Things are shaky now, and it's not worth it if the weather is really bad. Worse case I'll get ready for...

user databases, detach and attach.

For logins, you want to use sp_help_revlogin to script out logins and move them to the new instance.

I haven't tried the tasks to move jobs/alerts/etc from...

Do you mean the last time someone "USE"d the database? Or ran a query?

There's a default trace in 2005. If you think it's been awhile, set AUTO CLOSE for that...

There's no detection I'm aware of. I haven't used real media in years. Always downloaded, and looked x86 or x64 in the file name. Since a x86 will install on...

I second Gail's note. without an ORDER BY, you cannot count on any particular order of rows.

yes, fillfactor affects clustered indexes. It is there to either fill the pages for quicker IO (few changes) or make them sparse (low fillfactor) to allow for inserts and prevent...

Windows Backup was in Vista, and I think XP. I've used it a few times, weekly backups, and it worked OK for me. I recovered some stuff, though I never...

So, on the running.

The aim was a mile a day. I was inspired (http://amileaday.blogspot.com/2008/09/inspiration.html) by Jim Garrett and then found the US Running Streak Accoc. (http://runeveryday.com/). I started a...

You're welcome to come visit, Jay. lots of white stuff around here now.