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.

Some interesting comments, and it dovetails with some of the reading I've done. Sharepoint does some nice, easy applications, but if you try to completely customize it, the last 20%,...

Feel better, Roy. Glad you're OK. Rest and pain reliever

for jeff: Generalizing Specialists: Improving Your IT Career Skills

I don't think you accomplish anything with the bounce. The "rollback immediate" will kill sessions.

If you bounce the instance, then memory, cache, etc. reset.

the encryption is a one-way hash for SQL auth.

Why bounce the instance? What do they think that does? If you bounce a db, you aren't necessarily doing anything to the server. I'm not even sure if the cache...

Chad, please feel free to submit it. If it's new to you, it's probably new to 100s of others.