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...

I don't think there are any, but Personal does have some replication differences from the other versions, so it's possible. I develop most of my packages against personal and then...

I would load this all as text using DTS. Be sure you know what the delimeters are, but load it all into a single text row on the server. Then...

Or use a standard SQL login. The login failed message means you connected to the server, but were not authenticated. If the server port was not reachable, you could have...

Sounds like you're summing on the unknown date ranges in tblRetros if I read that correctly.

You might try building a self join of tblRetros with itself to get the date...

Agree with alzdba

Are there a limited number of matching values? Are there a limited number of columns you are looking for? Self joins will handle this, but you'd have to know how...

Get SQLPackager from RedGate. It's cheap, easy, and will make this bulletproof. It's like US$500, which is probably relatively few hours of your time, not to mention it's been tested,...