Viewing 15 posts - 10,741 through 10,755 (of 22,219 total)
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
ChrisM@Work (6/15/2012)
Brandie Tarvin (6/15/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 15, 2012 at 6:21 am
crazy4sql (6/15/2012)
If the backup file is of third party, you will get error which if 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 15, 2012 at 5:37 am
There isn't a mechanism that I'm aware to gather that information from MSDB or the backup headers. I've looked for it before and haven't found it. But I could be...
"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 5:11 am
Brent's suggestion to use the DMO queries is the closest you can get. Just remember that you're querying against the cache. That means that you can miss information if 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 15, 2012 at 4:57 am
Other suggestions are to validate the memory configuration and the disk alignment. I've posted this to #sqlhelp on Twitter.
OK. Stepping back for a minute. What kind of monitoring do 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 15, 2012 at 4:30 am
Viewing 15 posts - 10,741 through 10,755 (of 22,219 total)