Viewing 15 posts - 19,576 through 19,590 (of 22,220 total)
NPR did a report on it several weeks ago. According to the report the show has a pretty firm basis in reality, but instead of a few people in one...
"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
September 16, 2008 at 6:58 am
Yeah, open the query plan you posted. It's right there on top, including all the syntax except the query name to create it.
Here's the code (I used SQL 2008 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
September 15, 2008 at 12:57 pm
No, you can't index a query (per se), but it's suggesting an index on the table within the query. That bookmark lookup is costing you. If that index, with 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
September 15, 2008 at 12:44 pm
The bookmark lookup on TRNDTL_BTS08 is chewing up 90% of the cost of the query. The actual update changes a single row (according to this execution plan) but it has...
"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
September 15, 2008 at 12:11 pm
PeterG (9/15/2008)
The table i am retrieving from (trndtl_bts08) has 150mil rows.
i know how to display...
"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
September 15, 2008 at 11:13 am
Matt Miller (9/15/2008)
"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
September 15, 2008 at 10:43 am
Jeff Moden (9/15/2008)
"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
September 15, 2008 at 10:40 am
Have you looked at the execution plans to verify that the indexes were used at all?
For the clustered index, be sure that the column (or columns) that you put...
"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
September 15, 2008 at 10:33 am
Jeff Moden (9/15/2008)
"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
September 15, 2008 at 10:26 am
Different situations can cause either one to operate in a more optimal fashion.
Take the advice offered above. Do as proper a normalized design as you can to start. Then worry...
"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
September 15, 2008 at 8:27 am
msreddyn (9/15/2008)
Thanks Samrath ,thats what exactly i am looking for
Thank you very much
True, but use it the way Peso posted 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
September 15, 2008 at 8:24 am
jay holovacs (9/15/2008)
I spent a number of years doing C++ (and loved it). TSQL and C# are very different tools and they solve very...
"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
September 15, 2008 at 7:46 am
One thing I'm aware of in our organization, and I think it's universal. Object oriented developers loathe TSQL. I've watched blood pressures visibly rise in meetings when the discussion comes...
"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
September 15, 2008 at 6:53 am
With only a little modification, you could use the code in this article:
http://www.sqlservercentral.com/articles/T-SQL/61461/%5B/url%5D
"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
September 15, 2008 at 6:29 am
Performance, assuming a proper data design, good indexes, well written queries, etc., is not an issue. Supporting hundreds of users running queries is supporting hundreds of users running queries. 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
September 15, 2008 at 6:22 am
Viewing 15 posts - 19,576 through 19,590 (of 22,220 total)