Viewing 15 posts - 18,466 through 18,480 (of 22,226 total)
Yeah, that's pretty much my understanding too. Better & more memory management in the 64bit operating system, which benefits SQL Server.
I don't know where you heard that it's 32-bit only...
"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
February 6, 2009 at 8:10 am
It depends on the queries being run. The optimizer will take into account when an index is unique and it can improve performance, but it really does depend on 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
February 6, 2009 at 8:08 am
I forgot, swabbie, deck ape, blue jacket, airedale, a-ganger (nasty job).
"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
February 6, 2009 at 8:04 am
GilaMonster (2/6/2009)
"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
February 6, 2009 at 7:52 am
GilaMonster (2/6/2009)
"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
February 6, 2009 at 7:51 am
Lynn Pettis (2/6/2009)
Grant Fritchey (2/6/2009)
Lynn Pettis (2/6/2009)
"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
February 6, 2009 at 7:48 am
Chris Morris (2/6/2009)
Grant Fritchey (2/6/2009)
"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
February 6, 2009 at 7:45 am
Lynn Pettis (2/6/2009)
"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
February 6, 2009 at 7:11 am
Lynn Pettis (2/6/2009)
Grant Fritchey (2/6/2009)
"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
February 6, 2009 at 6:50 am
Oh, you want to verify that they have BOTH values, but if they have one or the other, it's no good to you?
OK then, how about joining to the table...
"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
February 6, 2009 at 6:48 am
I speak a bit of Southern, some Jersey, some Brooklyn. I'm very fluent in Navy, but really, it's just English with the f-bomb inserted every three to four words.
"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
February 6, 2009 at 6:43 am
How about using an OR statement between the two criteria?
"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
February 6, 2009 at 6:37 am
Sounds like possibly a permissions issue. Are the procs created with different schema's? Do you have permissions to those schema?
"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
February 6, 2009 at 6:34 am
You don't want the second one.
If the procedure is called, does it get the parameters as you outlined or does it get the literal values? Plan guides are extremely picky....
"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
February 6, 2009 at 6:32 am
The answer is the error message. You're trying to insert data that already exists and the primary key constraint, which ensures that the value in a column or columns is...
"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
February 6, 2009 at 6:30 am
Viewing 15 posts - 18,466 through 18,480 (of 22,226 total)