I'll take the kicks

I knew this one would get some action, but I did want to remember our veterans. Everyone should remember their...

Ah, skip Home Depot. Go to a local guy, support the little guy.

Are the tables linked? Otherwise, what you are doing will work, but be cumbersome. Is there some table of product families?

They both use T-SQL and SQL Server was ported from Sybase v4.2, but that was a long time ago. SQL Server 7 was a complete rewrite and while T-SQL was...

I'm curious, what are your reasons for moving?

Also, I believe Gabor is correct, the 64 bit SQL Server is only for Intel products. If you really want the move, you...

Also, the Versioning article by Andre Vigneau creates a proc to pull this back. Not updated for SP4 yet.

That's interesting. My inclination in adding a new column (non-text) is that the table is rebuilt with page splits, etc. moving the data from one page to another, making room...

I believe Frank is right. If you have stored procedures and other objects, I think they have to be dropped and recreated on a new filegroup to move them as...

As an FYI, Turbo is powering the search at SQLServerCentral.com.

Exactly. The idea of the question is offsite recovery. That is critical for a good backup plan and with all the hype on disk based systems, it is something you...

There are two links on the "Benefits" page. One for the current issue and one for archived issues. Don't ask me why, but I'm just glad they are up there.

One more suggestion. I'd be flexible in my planning. As you look at products, think about how they might be morphed, new options, etc. and plan for them. I've been...

I'd also put forth the argument that there have been hyperthreading issues reported with SQL Server. Lower performance in some cases. I'd try for the 8 CPUs myself with that...

Jay,

I agree with that and hopefully things are wonderul with you. I've learned to trust my instincts, and I always regret when I don't. So if I feel something...