Viewing 15 posts - 12,871 through 12,885 (of 22,227 total)
You need to identify which parts of the process are specifically hitting tempdb. That's step #1. Then you need to figure out what in those processes is causing tempdb 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 1, 2011 at 4:27 am
Michael Valentine Jones (3/31/2011)
Grant Fritchey (3/31/2011)
You can use a table valued parameter as an output parameter. But what are you trying to do?
I believe that is only available in SQL...
"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
March 31, 2011 at 4:19 pm
Craig Farrell (3/31/2011)
Grant Fritchey (3/31/2011)
Jeez, that guy (or girl) is lost. One more response and then I'm done. I'm the Scary DBA, not the Saintly DBA.
Oh, him. Yeah, I...
"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
March 31, 2011 at 3:23 pm
You can use a table valued parameter as an output parameter. But what are you trying to do?
"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
March 31, 2011 at 1:05 pm
I'm sorry, can you define the terms? What do you mean by CR?
"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
March 31, 2011 at 12:59 pm
Not sure I understand the question completely.
In the query optimizer there's a process called the Algebrizer that goes through the TSQL code and identifies all the pertinent objects. They actually...
"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
March 31, 2011 at 10:25 am
GilaMonster (3/31/2011)
David Benoit (3/31/2011)
Grant Fritchey (3/31/2011)
Jeez, that guy (or girl) is lost. One more response and then I'm done. I'm the Scary DBA, not the Saintly DBA.
If it is 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
March 31, 2011 at 8:27 am
Krasavita (3/31/2011)
"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
March 31, 2011 at 8:10 am
Jeez, that guy (or girl) is lost. One more response and then I'm done. I'm the Scary DBA, not the Saintly DBA.
"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
March 31, 2011 at 7:40 am
Krasavita (3/31/2011)
Hi, here is another stored procedure I found with a problem with nested Loop.Can you please help me to identifiy which update statment is wrong.Thank you so much
You're still...
"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
March 31, 2011 at 7:38 am
Let's assume that the view is fairly straight forward. It's a query against a table or a small set of tables that is properly configured. In that case, the optimizer...
"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
March 31, 2011 at 5:44 am
Sounds like a perfect solution for SQL Azure. You have data that you want everywhere you go, right? There it is.
"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
March 31, 2011 at 5:37 am
Last company I worked for made the decision to stay on 2008 on most servers because the licensing cost was too severe. The exceptions were SSRS servers, servers supporting spatial...
"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
March 30, 2011 at 7:34 pm
Jack Corbett (3/30/2011)
Grant Fritchey (3/30/2011)
Oh, and for those interested, I've heard through the grape vine that the call for speakers goes out soon and will be abbreviated this year. Get...
"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
March 30, 2011 at 6:35 pm
Again, maybe, maybe not. You're also looking at the resources on the system. How much memory is there? Is it possible that you've pushed the DBCC check to the point...
"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
March 30, 2011 at 6:31 pm
Viewing 15 posts - 12,871 through 12,885 (of 22,227 total)