Very strange. Is it possible the time was off on the new machine, or that the processes kicked off as part of rollback/rollforward?

Are you sure they kicked off because of...

Unless you have them set to start on startup, they should not run.

first, deleting all public permissions from master could cause you issues. There are procs in that that a normal user might need to access.

Second, what is "26"? What code are...

Ha, not sure my name means that much. However I would second recommendations on Kalen's books as well as Itzik Ben-Gan. I think Brian Knight, my former business partner here,...

That's one reason we try to only refer to the online BOL version. It changes quarterly, and local help can easily be out of date if you're not paying attention.

An FAQ is a lot of work, though it might make sense for an article to be posted that someone can maintain with a list of books to read.

Jan,

Glad you're enjoying it. Are you wood or metal bat down there?

I really enjoy it as well, and am looking forward to practice starting in about 30 days here for...

I'd think that an intra-query deadlock is a bug of some sort. However, it's a good point to be aware of.

Maybe they'll let you drive it around. Offer to "chauffer " kids one day around the parking lot to attract people.

And be sure you get a picture if they...

No hurry. I'll be out of town next week, but email me when you...

Paul means this model:

I'm not sure I agree with that, Colin. Depending on what the server is doing, 4GB could run it. It's a load issue.

Gail,

Thanks and either way. If you want to write it and deal with the comments, works for me. If not, it's an interesting thing to tackle.

On paid support. We talked...

Nice editorial, Brad, and glad to see you've changed your mind. I always recommend maintenance plans as a start. They work 80% of the time, and they are better than...

If this is running on a SQL 2000 server, use DTS. If it runs from SQL 2008, use SSIS.

In either case, you can use the Import Wizard to get you...