I strum around on an acoustic some nights. A little Sheryl Crow, John Mayer, few others.

It's recognizable, not sure how good it is.

Jack,

Write me a few articles this year and we might fund your trip. We usually get a couple free admissions to PASS, one going to Jeff Moden this year, and...

You can reach him here: http://www.minasi.com/

My apologies for the formatting. I'm not sure what the text editor did to the article, but it has been reformatted to fit on the screen.

You might try Mark Minasi. He does seminars all over the US on Windows and is a highly recommended speaker.

My recommendation is based on working with 2005 and 2008, and finding that they are very similar in core features. Very little was changed. Things were added, but not much...

There are a few writeups over the years here on the site as well. Search for "PASS Summit" and you'll get some idea of what happens at the conference.

Jim,

How important is it for you to see us move? I'm wondering because I bet we could move today, but we don't really take advantage of much of SQL Server....

It depends. I tend to refer all questions for help to the forums so others can see the answer. I almost never answer something in email.

You can always go PM...

Someone beat me to it.

I'm 2.1GB of 3.1GB down now. Not moving too fast 🙁

Error log?

I think a Trace on sp_start_job might be the best way to pro-actively get this.

Don't have many writers, so this isn't much of a priority.

You're welcome and I'd love any you want to submit. Keep in mind answers must be short, not HTML allowed...

Quite a few of the heavy posters use the "Active Threads" link to check for changes since their last login and the post count is shown. That's how I scan...

You could left join with a table of all periods, including 0s for NULLs (CASE or ISNULL).

Or you could "populate" 0 orders with the missing periods.

Cursor opens a copy of the data, essentially and holds it. This isn't the most efficient way to do things. A While loop typically reruns a query to check if...