Viewing 15 posts - 17,266 through 17,280 (of 22,226 total)
Actually, though... thinking about it. I'm not sure you could make a plan guide work. Hmmm... that might be tough.
"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
June 9, 2009 at 9:10 am
You can using a hint, but since this is ad hoc (right?) you'll need to use a plan guide.
"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
June 9, 2009 at 9:09 am
Excellent.
So you are using forced parameterization then?
"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
June 9, 2009 at 8:44 am
The different plans from the web is probably, but not definately, because of differences in the type of connection or settings within the connection. If you drill down on all...
"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
June 9, 2009 at 8:31 am
GSquared (6/9/2009)
Steve Jones - Editor (6/8/2009)
Back from SQLSaturday #14 in Pensacola, what did I mess?
Okay, Steve. Normally I back you up when you have typos in articles and someone...
"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
June 9, 2009 at 8:23 am
Well, again, any plan will be cached and could be reused. As to whether or not simple is doing what you want, when you look at the query text 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
June 9, 2009 at 6:45 am
You might want to pick up a book on the topic. It's as old as the hills in computer terms, but Flemming & von Halle's Handbook of Relational Design 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
June 9, 2009 at 6:40 am
Here's the What's New listing on 2008
http://msdn.microsoft.com/en-us/library/bb500435.aspx
"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
June 9, 2009 at 6:39 am
I haven't been too crazy about it, but Books24x7 has a very good service.
"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
June 9, 2009 at 6:37 am
It sounds like something in your code is trying to create the index, probably over & over again. You should check the code. I don't think you're dropping 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
June 9, 2009 at 6:36 am
I support quite a few development teams. I usually take charge of creating their databases, setting up backups & restores and then, depending on the team, their level of expertise,...
"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
June 9, 2009 at 6:35 am
Without the things that Gail asked for... No. No one can tell you what's wrong because we're not there and don't have a clue what's the problem on your end....
"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
June 9, 2009 at 6:29 am
Have you updated the statistics recently and if so, have you tried updating with a full scan? There is a bit of a discrepancy between the estimated rows & 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
June 9, 2009 at 6:13 am
If you use the result set to show success, just prepare your code handle multiple result sets because you'll need one for the success criteria and one for the data...
"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
June 9, 2009 at 5:34 am
Just so the next person along can understand, can you post the solution?
"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
June 8, 2009 at 12:55 pm
Viewing 15 posts - 17,266 through 17,280 (of 22,226 total)