Well said Brian.

and cognospam, if you haven't disparaged people with your first statement, I'm not sure I'd like to see it when you do.

no one here claims MVPs are the...

Looks like they're right here.

Or we have someone upset they didn't get some recognition.

There are plenty of job openings in the US. They can be spread around, but lots of people use SQL 2000. Lots more are looking to upgrade since 2000 support...

You also don't want to shrink it unless some event made it much larger than needed. You should have free space in the file to handle data and index growth...

You have to understand a bit more about the log file to see the difference, but I'll give a short explanation. You can get more details in Books Online.

The log...

tony,

SQL Server Express 2005 is the same as SQL Server 2005 for database formats, so SQL 2000 won't work.

You could install SQL Server 2005 Express as a named instance on...

Really think about this. Everyone says they need real-time reporting, but very few people need it. Often every hour is fine.

It's got to be a Groupwise thing then. I had someone say that Outlook 2003 might be problematic as well.

Are you sure you're pulling down pictures and that your image...

I'd argue against the marketing comment for the most part. There are people that fit that category. Without a doubt.

But most of the MVPs I know, and I think I...

I'd say it's appreciating what you have, striving to get more, but understanding that things are things, and not nearly as important as other things in your life.

Now, now, Jeff. We typically spread manure, not haul it. I think it's more like using a handheld grass spreader to distribute manure 😉

They'll certainly give us lots of questions to answer!

checkpoints are roughly every few minutes. Not sure how this impacts what you're trying to do.

You need to set it to get a subquery to get the aggregate.

So

create table MyTable

( myID int

,salesdate datetime

, myval int

)

go

create table NewTable

( myID int

...

One time thing or a process?

One time, use QA. run the query, right click the upper left, save as.

Process, use DTS. The data export wizard will help you build the...