Viewing 15 posts - 10,201 through 10,215 (of 22,232 total)
anil.janu143 (1/9/2013)
can anyone provide code for solution please.. because i am not able to understand the theory part..thanx in advance....
Since no one is sitting at your desk with a full...
"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
January 9, 2013 at 8:44 am
I'm still back to hard to say, but, in general, I would avoid holding open a query, on purpose, for 15 minutes under any circumstances. The fundamental concepts of transactions...
"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
January 9, 2013 at 5:12 am
jitendra.padhiyar (1/8/2013)
You explain me what exactly statisc is and what the sql server doing during update statics. Can you pls clear my more doubts?
1. Is 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
January 9, 2013 at 4:55 am
Kishore-132325 (1/7/2013)
"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
January 9, 2013 at 4:50 am
It's hard to know if it will create a deadlock or not without being able to compare other code to understand where locks might occur. Will it create a blocking...
"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
January 9, 2013 at 4:48 am
Sort operations also hit tempdb. If you have read committed snapshot enabled on any of the databases, they're going to use tempdb. There are just lots and lots of uses...
"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
January 9, 2013 at 4:43 am
If the column has statistics on it, those represent the data distribution as SQL Server understands it. You can use DBCC SHOW_STATISTICS to see the density, also known as selectivity,...
"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
January 9, 2013 at 4:41 am
You'll need to monitor the size of your logs and possible the tempdb. Make sure you have enough disk space for all the additional information.
"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
January 9, 2013 at 4:38 am
Filestream would be the preferred method if you have to store things within the database. You can store them in a varbinary(max) column, but you have to deal with special...
"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
January 9, 2013 at 4:37 am
hisakimatama (1/8/2013)
"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
January 8, 2013 at 12:52 pm
They want ALL that and only want to pay $55k? I'd tell 'em where to shove that. That's crazy.
"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
January 8, 2013 at 12:39 pm
Yeah, not sure. That syntax looks a little odd. It's not a sqlcommand parameter. It' not a normal parameter. Best thing would be to go back and reread whatever documentation...
"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
January 7, 2013 at 4:52 am
Sounds like whatever transaction was running stopped and the tempdb emptied back out. Normal, if unfortunate, behavior. I'd try to track down where that query came from because, if your...
"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
January 7, 2013 at 4:48 am
Differentials only capture data changes since the last full backup. And, differentials won't help you with the logs. The best answer is to follow Gail's advice and run more frequent...
"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
January 7, 2013 at 4:46 am
I don't suppose you still have the original question? Anyone else searching for similar help can benefit from the question and answer. Editing it away makes it more difficult 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
January 7, 2013 at 4:44 am
Viewing 15 posts - 10,201 through 10,215 (of 22,232 total)