Viewing 15 posts - 12,871 through 12,885 (of 22,224 total)
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
GilaMonster (3/30/2011)
For your amusement, this (attached) was part of a project plan I received today, specifically the test plan....
And that blank spot is where the miracle occurs?
"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 12:20 pm
CirquedeSQLeil (3/30/2011)
using the spid of that process, use dbcc inputbuffer 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
March 30, 2011 at 12:19 pm
Chad Crawford (3/30/2011)
Wahoo! After 4 months of wrangling, got the PASS Summit approved (and paid for) today!
congratulations.
Oh, and for those interested, I've heard through the grape vine that...
"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 11:56 am
Viewing 15 posts - 12,871 through 12,885 (of 22,224 total)