Viewing 15 posts - 15,481 through 15,495 (of 22,219 total)
anthony_merriwether (4/19/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
April 19, 2010 at 10:20 am
anthony_merriwether (4/19/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
April 19, 2010 at 10:16 am
I agree. Is that the size of the database you want? If so.... there you go. If not, yeah, you might want to shrink the files. Regardless, once you backup...
"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
April 19, 2010 at 7:36 am
You won't be able to disable by job across multiple servers in one step. Probably the best way to do it would be to write a PowerShell script that walked...
"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
April 19, 2010 at 7:03 am
There could be any number of reasons and without more detail, it will be very difficult to guess.
The first two guesses that come to mind are either parameter sniffing or...
"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
April 19, 2010 at 7:01 am
No, there should be no connection to the production system while you are testing the dev system.
Be very cautious about applying the DTA recommendations. It's notorious for picking poor...
"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
April 19, 2010 at 6:59 am
I agree with almost all of the advice here with one exception... DTA is a pile.
For anything beyond the simplest mom&pop sized database, it's recommendations are so horrendously dangerous...
"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
April 19, 2010 at 6:57 am
I'm surprised you're not getting errors, because you should
CREATE TABLE #tblPartners
(
c_id int,
...
"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
April 19, 2010 at 6:55 am
Well, add it up. You have 2gb of data plus 13gb of free space:
2+13 = 15
Which means that it needs to allocate 15gb, give or take, to recreate the existing...
"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
April 19, 2010 at 6:52 am
I'm not entirely sure I understand the question, but you could use SSIS packages, as suggested, to move the data on a regular basis, or you could set up replication...
"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
April 19, 2010 at 6:47 am
It sounds like your log file is of sufficient size. As was noted, you may have a log backup process running. Your system might also be in simple recovery mode,...
"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
April 19, 2010 at 6:46 am
The upgrade advisor functions, I know because I've used it on multiple machines. So the problem is either your installation or your OS. Clean it up, download a new copy,...
"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
April 19, 2010 at 6:44 am
That's a tough one, it really depends on a lot of factors, but a rollback frequently takes about as long as the orginal transaction. Sometimes it takes less time, 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
April 19, 2010 at 6:42 am
I'm 100% with Steve. Backup locally, to a seperate drive from any logs or data, and then copy to tape or network shares as appropriate.
In our case, we're on 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
April 19, 2010 at 6:31 am
Did the query itself complete? If not, it's still restoring.
"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
April 19, 2010 at 6:29 am
Viewing 15 posts - 15,481 through 15,495 (of 22,219 total)