Viewing 15 posts - 15,496 through 15,510 (of 22,227 total)
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
Jack Corbett (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 6:16 am
jabadwy (4/19/2010)
Here Adi has made a point about size of nc index in comparison to clustered....which makes some sense to...
"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:12 am
To see what's running you go to sysjobactivity in the msdb database.
"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:06 am
Steve Jones - Editor (4/18/2010)
Grant Fritchey (4/18/2010)
lmu92 (4/18/2010)
Is Google down?I usually is... or maybe all those millions I pay for exclusive rights to use it is the thing?
I don't...
"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 5:41 am
lmu92 (4/18/2010)
Is Google down?
I usually is... or maybe all those millions I pay for exclusive rights to use it is the thing?
"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 18, 2010 at 6:16 am
Jeff Moden (4/17/2010)
Speaking of PASS, Grant... any idea when they're going to start a "Call for Speakers"?
My understanding is it was supposed to be in April. Last year I got...
"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 17, 2010 at 8:11 pm
Steve Jones - Editor (4/17/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 17, 2010 at 9:45 am
Viewing 15 posts - 15,496 through 15,510 (of 22,227 total)