Viewing 15 posts - 33,961 through 33,975 (of 39,736 total)
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...
June 1, 2005 at 8:05 am
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...
June 1, 2005 at 8:03 am
As an FYI, Turbo is powering the search at SQLServerCentral.com.
June 1, 2005 at 7:46 am
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...
June 1, 2005 at 7:43 am
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.
May 31, 2005 at 9:44 am
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...
May 31, 2005 at 9:32 am
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...
May 31, 2005 at 9:29 am
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...
May 31, 2005 at 9:27 am
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...
May 31, 2005 at 9:23 am
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...
May 31, 2005 at 9:22 am
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...
May 31, 2005 at 9:21 am
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...
May 31, 2005 at 9:20 am
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...
May 31, 2005 at 9:12 am
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,...
May 31, 2005 at 9:11 am
Viewing 15 posts - 33,961 through 33,975 (of 39,736 total)