Viewing 15 posts - 15,481 through 15,495 (of 22,227 total)
jvanderberg (4/19/2010)
Grant Fritchey (4/19/2010)
Another option would be to use a minimally-logged operation such as bcp or BULK INSERT.
I'm confused as to how BCP or BULK INSERT would help, considering the...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 19, 2010 at 12:41 pm
It sounds like it's doing everything through a single, logged operation. As long as you do this, you'll need this much space, as Lynn says. You either have to live...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 19, 2010 at 12:14 pm
I use to have A which caused me to do a lot of C, so I'd have to choose D - none of the above.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 19, 2010 at 11:11 am
To my knowledge this works the same way as if you were restoring a 2000 backup, the binary being stored is converted to the new version by the restore process....
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 19, 2010 at 10:58 am
It's that second one. And just about as useful.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 19, 2010 at 10:57 am
Ah, well, it is a Troll after all. Clarification is a wonderful thing.
Everyone knows the rule. Don't feed it more than we already have. It'll get hungry & go elsewhere.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 19, 2010 at 10:47 am
Perry Whittle (4/19/2010)
Grant Fritchey (4/19/2010)
For anything beyond the simplest mom&pop sized database, it's recommendations...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 19, 2010 at 10:32 am
CirquedeSQLeil (4/19/2010)
And same with bing - do we bing it or are we binging...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 19, 2010 at 10:21 am
anthony_merriwether (4/19/2010)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 19, 2010 at 10:20 am
anthony_merriwether (4/19/2010)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 19, 2010 at 10:16 am
I agree. Is that the size of the database you want? If so.... there you go. If not, yeah, you might want to shrink the files. Regardless, once you backup...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 19, 2010 at 7:36 am
You won't be able to disable by job across multiple servers in one step. Probably the best way to do it would be to write a PowerShell script that walked...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 19, 2010 at 7:03 am
There could be any number of reasons and without more detail, it will be very difficult to guess.
The first two guesses that come to mind are either parameter sniffing or...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 19, 2010 at 7:01 am
No, there should be no connection to the production system while you are testing the dev system.
Be very cautious about applying the DTA recommendations. It's notorious for picking poor...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 19, 2010 at 6:59 am
I agree with almost all of the advice here with one exception... DTA is a pile.
For anything beyond the simplest mom&pop sized database, it's recommendations are so horrendously dangerous...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 19, 2010 at 6:57 am
Viewing 15 posts - 15,481 through 15,495 (of 22,227 total)