Viewing 15 posts - 10,741 through 10,755 (of 22,224 total)
NO! Don't use readuncommitted or nolock. Those lead to differences in the data returned by the query[/url] and are generally not a good solution.
Instead, first, tune the query. All those...
"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
June 19, 2012 at 5:24 am
george sibbald (6/19/2012)
Grant Fritchey (6/18/2012)
I doubt you're seeing major performance hits from the fragmentation, .why do you say that grant?
Just because, at least from what you've posted, the tables are...
"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
June 19, 2012 at 5:03 am
Suresh B. (6/19/2012)
how to ensure that correct execution plan is created and used every time it executes ?
Add OPTION (HASH JOIN) at the end of the query.
how to check 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
June 19, 2012 at 4:51 am
WayneS (6/18/2012)
Me, your humble dba, from out of the blue, happened...
"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
June 19, 2012 at 3:56 am
I doubt you're seeing major performance hits from the fragmentation, but I'd go ahead and defragment anyway. You're only storing, on average, 1.6 pages per extent, so you'll get some...
"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
June 18, 2012 at 4:05 pm
Sapen (6/18/2012)
Just tried it and it worked. Assuming you're using the gui, delete the log file that it automatically tries to create. Remove that, then attach just the .MDF and...
"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
June 18, 2012 at 12:33 pm
Lynn Pettis (6/18/2012)
Grant Fritchey (6/18/2012)
Lynn Pettis (6/18/2012)
Grant Fritchey (6/18/2012)
Lynn Pettis (6/18/2012)
Have to ask first, why are you trying to attach the mdf file without its associated ldf file?
That's how you...
"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
June 18, 2012 at 11:58 am
Lynn Pettis (6/18/2012)
Grant Fritchey (6/18/2012)
Lynn Pettis (6/18/2012)
Have to ask first, why are you trying to attach the mdf file without its associated ldf file?
That's how you get the 2012 OLTP...
"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
June 18, 2012 at 11:41 am
Stueyd (6/18/2012)
"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
June 18, 2012 at 11:39 am
Just tried it and it worked. Assuming you're using the gui, delete the log file that it automatically tries to create. Remove that, then attach just the .MDF and 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
June 18, 2012 at 11:00 am
Lynn Pettis (6/18/2012)
Have to ask first, why are you trying to attach the mdf file without its associated ldf file?
That's how you get the 2012 OLTP AdventureWorks2012 sample database. It's...
"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
June 18, 2012 at 10:57 am
Just to help you troubleshoot a bit in the future, take a look at the plan. Right click the SELECT operator and choose properties. For the plan run from a...
"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
June 18, 2012 at 9:07 am
Yeah, no way I'm aware of either. The only way to remove the possibility for an index to be used is, drop it, disable it, or put an index hint...
"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
June 18, 2012 at 5:35 am
Have you looked at the execution plan for the query? That will tell you what it's doing and will help you determine if there are further tuning opportunities available for...
"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
June 18, 2012 at 5:33 am
Trying to break down the query from the execution plan, but it's too big. It's not all contained there.
You're getting an optimizer timeout on this query, so you can't trust...
"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
June 15, 2012 at 8:04 am
Viewing 15 posts - 10,741 through 10,755 (of 22,224 total)