Viewing 15 posts - 15,256 through 15,270 (of 22,221 total)
It really depends on how many cpu's you have. Zero sets it to use as many as it has available. Setting it to 1 limits it to a single cpu.
"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 29, 2010 at 8:30 am
Paul White NZ (4/29/2010)
Grant Fritchey (4/29/2010)
Thanks. I'll pass it on if you haven't already.
I replied on Ask, but thanks for posting the thread reference there too.
I don't usually post on...
"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 29, 2010 at 8:28 am
Sqlfrenzy (4/29/2010)
Grant Fritchey (4/29/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 29, 2010 at 8:27 am
It's not parallelism itself that's the issue, it's the cost threshold. The default value of 5 is ridiculously low. I'd suggest starting off with it at 25 and see things...
"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 29, 2010 at 8:06 am
GilaMonster (4/29/2010)
Grant Fritchey (4/29/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 29, 2010 at 8:02 am
ricardo_chicas (4/29/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 29, 2010 at 7:56 am
Paul White NZ (4/29/2010)
Grant Fritchey (4/29/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 29, 2010 at 7:54 am
krypto69 (4/29/2010)
Im trying to use your statement:
But when I run the below code I get the error:
"Must declare the scalar variable "@CUTOFFDATE".
declare @DaysToRetainSMALLINT
DECLARE @cutoffdate DATE
SET @daystoretain = '1'
SET @cutoffdate =...
"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 29, 2010 at 7:52 am
But... almost forgot this, part of why you use monotonically increasing values as clustered keys so often (or identities defaulted to the primary key) is because inserts always occur at...
"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 29, 2010 at 7:50 am
It's down to page splitting as inserts and updates occur, the data may not fit on a given page. At that point the page is split. Half the data remains...
"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 29, 2010 at 7:48 am
If this turns out to be gigs, I'm going to cry. I was terribly excited about an 800TB system.
"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 29, 2010 at 7:35 am
Stefan_G (4/29/2010)
Paul White NZ (4/28/2010)
kinzent (4/28/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 29, 2010 at 7:18 am
I didn't say it "can't" be 100tb, I said it probably shouldn't be. You can have a tlog hundreds of times the size of your database, but that doesn't make...
"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 29, 2010 at 7:15 am
Jeff, or anyone else that knows a heck of a lot more about decimals than I do, please go check this question on Ask.SQLServerCentral. I really don't have a clue,...
"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 29, 2010 at 6:59 am
You will need to upgrade that license.
"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 29, 2010 at 6:54 am
Viewing 15 posts - 15,256 through 15,270 (of 22,221 total)