Viewing 15 posts - 15,136 through 15,150 (of 22,219 total)
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
Lynn Pettis (5/5/2010)
Just a little short I may have been.
Oh, I went over there expecting a good thumping. That was a reasonable response.
"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 10:27 am
Read uncommitted is pretty dangerous for any number of reasons.
Most systems I work with are Read_Committed for all the details provided above. Some of the newer systems under development in...
"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 10:23 am
view server state is not the same as sysdmin. It allows the user to view server level objects, not manipulate them. There is also a view database state. You could...
"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 10:20 am
It does sound like a permissions issue. I've never had any problem working with 2005 from the 2008 SSMS. It is possible that SSMS tries to do things in 2008...
"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 10:19 am
Robert Frasca (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:29 am
kinzent (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:27 am
Chris Morris-439714 (5/5/2010)
GabyYYZ (5/5/2010)
Steve Jones - Editor (5/5/2010)
Gianluca Sartori (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 7:53 am
First you need to identify if you are seeing blocking as the primary source of your performance problems. The best way to do this is to monitor the wait states...
"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 7:51 am
Viewing 15 posts - 15,136 through 15,150 (of 22,219 total)