Viewing 15 posts - 10,846 through 10,860 (of 22,219 total)
Jeff Moden (5/27/2012)
Revenant (5/26/2012)
Steve Jones - SSC Editor (5/25/2012)
Jeff Moden (5/25/2012)
Brandie Tarvin (5/25/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
May 29, 2012 at 4:27 am
When you're defining a join, you should define the columns that join the two tables together. So that you're ON condition is something along the lines of
A.ID = B.ID
If...
"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
May 25, 2012 at 8:10 am
Gianluca Sartori (5/25/2012)
paul.knibbs (5/25/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
May 25, 2012 at 5:52 am
If you can post the execution plans, I would be guessing less, but, guessing, I'd say that it's probably a parameter sniffing issue. Take a look at the estimated values...
"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
May 25, 2012 at 5:03 am
This is a classic issue for backups and one that leads to severe problems when you try to recover these backups. I detail this issue, along with a few others,...
"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
May 25, 2012 at 4:55 am
It's certainly possible that's the cause, but I'd be more concerned that the query is identical between both databases and, more importantly, that the statistics are updated in exactly 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
May 25, 2012 at 4:51 am
Are we talking connections or transactions? If you have 4000 open & uncommitted transactions, yeah, I'd be having screaming fits right about now. That's locks being held open, possibly leading...
"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
May 25, 2012 at 4:47 am
The reads measures are based on pages, yes.
As for time, it really depends on where you're getting the measure and what you're looking at. If, for example, you're looking at...
"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
May 25, 2012 at 4:45 am
rkumar590 (5/25/2012)
Thanks for your reply.
Is the sp_cursorclose;1 depends on the Number of records it has been processed by the update which was run before it or it depends on...
"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
May 25, 2012 at 4:37 am
jez.lisle (5/24/2012)
I want to create a StoredProc that runs an Insert query into a table.
My main data table contains details around appts for customers. ApptID,...
"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
May 24, 2012 at 3:58 am
rkumar590 (5/24/2012)
I am facing a weird issue ,during the processing of the certain tasks from Application,some part of time we are observing blocks in our database.
Processing ,load are quite...
"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
May 24, 2012 at 3:50 am
There's a task scheduler built right into the OS. I'd just use that utility if all you needed was the ability to schedule tasks. You would have to pay 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
May 24, 2012 at 3:47 am
Based on the fact that it's literally twice the size of the others, I would wonder if you have two backups there instead of one? Check to see if 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
May 23, 2012 at 12:58 pm
PradeepVallabh (5/23/2012)
Thanks for the info...While analysing execution plan i noticed something called Estimated Number of Execution...what does it mean??
Parts of the execution plan are iterative. This means parts can 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
May 23, 2012 at 12:46 pm
TheSQLGuru (5/23/2012)
Grant Fritchey (5/22/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
May 23, 2012 at 6:47 am
Viewing 15 posts - 10,846 through 10,860 (of 22,219 total)