Viewing 15 posts - 15,151 through 15,165 (of 22,232 total)
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
Since this is homework, you need to show the work you've done already.
In order for someone to really help they're going to need to see the structure of the tables...
"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:41 am
Roy Ernest (5/5/2010)
Grant Fritchey (5/5/2010)
Roy Ernest (5/5/2010)
My article is out on SQL Server Standard in SQLPass site. I have been waiting for this day. Happy day for me....
"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:07 am
Viewing 15 posts - 15,151 through 15,165 (of 22,232 total)