Viewing 15 posts - 18,376 through 18,390 (of 22,226 total)
I'm with you on this one. If it's "too big to fail" time to tear it right the f' down now.
"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
February 14, 2009 at 12:21 am
Florent Rousseau (2/13/2009)
I also use some dynamically written queries and also ran into the limit of the maximum string length (VarChar(8000)).
I solved it by cutting down the whole query in...
"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
February 13, 2009 at 11:07 am
GSquared (2/13/2009)
(I can legitimately and truthfully claim that I dropped out of both kindergarden and college. Not many with those...
"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
February 13, 2009 at 9:30 am
I don't have a Bachelors. So there!
And I don't have a single certification (well, a 14 or 15 year old one from Sybase, but I'm pretty sure that doesn't count).
"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
February 13, 2009 at 9:11 am
Lynn Pettis (2/13/2009)
If that isn't what the OP meant,...
"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
February 13, 2009 at 8:55 am
GilaMonster (2/13/2009)
Grant Fritchey (2/13/2009)
There's a blog post. Do you get it or do I?
Why not both? (Like we did with the table-valued functions)?
I'll write one over the weekend. Title's...
"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
February 13, 2009 at 8:44 am
Two options. First, UNION all three statements together. Then you'll get all the James data.
Option 2, check for @@ROWCOUNT to see if you have any data with an IF statement.
"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
February 13, 2009 at 8:43 am
Lynn Pettis (2/13/2009)
No. Running the query above prior to creating the clustered index will have no affect at all on the create index statement.
Actually won't it slow everything down?...
"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
February 13, 2009 at 8:41 am
sam (2/13/2009)
"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
February 13, 2009 at 8:34 am
GilaMonster (2/13/2009)
The terms estimated and actual for plans are actually a bit of a misnomer....
"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
February 13, 2009 at 8:30 am
Grant Fritchey (2/13/2009)
"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
February 13, 2009 at 8:27 am
Yeah, you're probably running into schema issues. If the schema defining the object is anything other than the default schema for the connection, you can't simply call the proc.
"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
February 13, 2009 at 7:52 am
Brandie Tarvin (2/13/2009)
I've heard those too. I certainly will. @=)Hmm. I also need to write another article for the site. I wonder what I shall compose...
I owe Steve an article...
"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
February 13, 2009 at 7:49 am
Again, I'm just getting started supporting it. However, I found some fun stuff in nHibernate that is going to seriously impact our performance over time. For example, check out my...
"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
February 13, 2009 at 7:47 am
Yeah, that's how you get the actively executing plan. It must show the estimated plan while executing... I can't find documentation that says it would show the estimated plan though......
"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
February 13, 2009 at 7:43 am
Viewing 15 posts - 18,376 through 18,390 (of 22,226 total)