Viewing 15 posts - 16,816 through 16,830 (of 22,226 total)
I "answered" this post, but I didn't provide a solution to the guy. If someone else would like to take a swing at providing a possible solution for him, he...
"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
August 3, 2009 at 6:59 am
You want an honest answer? Don't do this. Don't use functions in this manner. I've seen an entire application written exactly the way you described. It looked great and when...
"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
August 3, 2009 at 6:55 am
Lynn Pettis (8/2/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
August 3, 2009 at 5:26 am
Working on it. Sorry. Work interfered.
"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
July 31, 2009 at 1:07 pm
mazzz (7/31/2009)
Steve Jones - Editor (7/24/2009)
clean, used books? give me a battered, dirty, bent copy any day, as long as all the pages are in there!
Same here- the first...
"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
July 31, 2009 at 9:50 am
Sorry, WITH X AS (SELECT), is the syntax for a common table expression, CTE.
Can you post the structure & some sample data. I can play with the proc then. Index...
"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
July 31, 2009 at 8:39 am
I agree. Go ahead and give people as much as they feel they need without endangering your system. They may need it.
"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
July 31, 2009 at 7:55 am
Is there an index in Opportunities on the AccountID? Are your indexes defragmented and the statistics up to date? How selective is the data within the Account table?
Based on what...
"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
July 31, 2009 at 7:53 am
It looks OK. You don't need to use a CTE to do the UPDATE, you can simply UPDATE... FROM and select what you need, but it won't change the overall...
"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
July 31, 2009 at 7:34 am
I guess my question is, why would you NOT go to one of these events? Fear that maybe the people presenting don't know what they're talking about? So leave 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
July 31, 2009 at 7:32 am
It could be compile time or the time needed to move the data into cache or both.
"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
July 31, 2009 at 6:02 am
You must be getting a scan because you're not going to see an index seek when you have functions on columns like that. Like Gail says, post the code, structure,...
"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
July 31, 2009 at 6:01 am
No, an index hint doesn't change the order. The only way to affect the order of the data returned is to use an ORDER BY clause. That will take advantage...
"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
July 31, 2009 at 5:50 am
Many of the SSIS operators have the ability to pull rows with errors into a seperate path where you can store them, fix them, whatever, all without shutting down 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
July 31, 2009 at 5:45 am
There's only been one large free SQL specific event locally. I presented at it, and helped put it on (although Adam Machanic did most of the work), which technically means...
"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
July 31, 2009 at 5:40 am
Viewing 15 posts - 16,816 through 16,830 (of 22,226 total)