Viewing 15 posts - 16,801 through 16,815 (of 22,219 total)
Sorry, only the ones that are associated with the index that was rebuilt.
"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 1:24 pm
Didn't you just ask this question under a different topic?
Please don't do that. It makes conversations harder to track.
Actually Steve, if I'm understanding the question, I think the answer 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
August 3, 2009 at 1:18 pm
Yes. When the index rebuilds, as oppose to reorganize, the statistics are updated and the procedures referncing those statistics are all marked for recompile.
"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 1:14 pm
Well, instead of MAX and an aggregate function, I'd suggest using TOP 1 and an ORDER BY if you can supply a column that can be ordered in such a...
"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 9:18 am
Because I know that a bunch of you will qualify:
http://scarydba.wordpress.com/2009/08/03/sql-server-standard/%5B/url%5D
Please consider taking part.
"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 8:30 am
Inline UDF's are not usually a problem because, as you can see in the execution plan, they'll resolve out to a standard set of operations, like a view (unlike 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
August 3, 2009 at 7:32 am
It looks basically OK, but I'm curious why you're aggregating the data & selecting the max value. Are there multiple entries with the same key value? That's a bit of...
"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 7:10 am
You wouldn't by chance be running the Profiler GUI against this server? If so, I'd suggest turning that off and using scripts to create a server-side trace routine. I say...
"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 7:04 am
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
Viewing 15 posts - 16,801 through 16,815 (of 22,219 total)