Viewing 15 posts - 15,136 through 15,150 (of 22,227 total)
what events are you tracing? You could see this if you were tracing statement and rpc complete, for example.
"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
May 5, 2010 at 8:16 pm
R2 is basically an upgrade. Depending on your licensing with MS, you'll need to buy a new one to move to it. It's not simply a service pack.
"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
May 5, 2010 at 8:15 pm
CirquedeSQLeil (5/5/2010)
Grant Fritchey (5/5/2010)
Lynn Pettis (5/5/2010)
Paul White NZ (5/5/2010)
Lynn Pettis (5/5/2010)
Grant Fritchey (5/5/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
May 5, 2010 at 8:12 pm
Can you post the specific error?
"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
May 5, 2010 at 5:31 pm
I agree with Jeffrey, but not because I'd be sweating the SAN just going down. By and large those things don't go away. I'd do it because you never know...
"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
May 5, 2010 at 5:30 pm
Maybe you mean you validated the backup and it failed, or you ran DBCC against the restored database and that failed.
"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
May 5, 2010 at 5:29 pm
tosscrosby (5/5/2010)
Strappado
Pass, thank you, and that's without following the link.
"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
May 5, 2010 at 5:23 pm
Lynn Pettis (5/5/2010)
A gauntlet has been thrown down. Am I up to challenge? We shall see.
He does seem completely certain that there is no possible solution. I'd hesitate...
"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
May 5, 2010 at 5:22 pm
Lynn Pettis (5/5/2010)
Paul White NZ (5/5/2010)
Lynn Pettis (5/5/2010)
Grant Fritchey (5/5/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
May 5, 2010 at 5:20 pm
Make sure you've got your kilts in order gentlemen. Kilt Wednesday at the PASS Summit is going to be a happenning event this year.
"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
May 5, 2010 at 1:38 pm
And the developers can change the isolation level with connection properties as well.
"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
May 5, 2010 at 1:36 pm
And hash tables for join operations and table spools and lazy spools and index rebuilds and...
You get the picture. Tempdb is a major source of operational space in the server,...
"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
May 5, 2010 at 1:25 pm
If there are only five values for that guid, it's very unlikely you'll see improved performance from it.
You can tell what SQL Server is doing with indexes by looking 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
May 5, 2010 at 12:12 pm
I'd say it's time to learn it. There is just so much capability built into it now from MS plugging it into every product they're turning out these days... It...
"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
May 5, 2010 at 12:06 pm
So there are only 5 values for the GUID and you're proposing using it as the leading edge of the index?
No, that's a problem. You're going to find that 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
May 5, 2010 at 11:46 am
Viewing 15 posts - 15,136 through 15,150 (of 22,227 total)