Viewing 15 posts - 18,496 through 18,510 (of 22,226 total)
It's possible for the compile time to be outrageous. We had an 80 table JOIN, plus an extensive WHERE clause that took 45 seconds to compile but only about 1.5...
"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 5, 2009 at 5:55 am
The last post is close. You do want to use the OUTPUT clause. But instead of trying to use it one row at a time, which is likely to be...
"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 5, 2009 at 5:51 am
colin Leversuch-Roberts (2/5/2009)
but I found the documentation to be...
"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 5, 2009 at 5:44 am
KSB (2/4/2009)
The first question I would ask is, do you really need 8000+ rows?
Yes, I want all these 8000 rows.
For example, you're getting a scan on dim_project_secure's clustered...
"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 5, 2009 at 5:41 am
1) It's just not open for the kind of manipulation I'm used to making
2) I don't have access to the tools it needs
3) Because I've been told to keep 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 5, 2009 at 5:35 am
The only problem with Trace, and it's rather big, is that it's single threaded. So instead of multiple threads for multiple sessions, you get a single thread for all sessions....
"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 4, 2009 at 6:06 pm
And I've been staying out of the way since this was identified as PeopleSoft. Same approach I take at work.
"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 4, 2009 at 6:04 pm
Andrew Reilly (2/4/2009)
I think that a lot of us would like just thatUnfortunately as far as i know there is no way of doing this without using Profiler
You can...
"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 4, 2009 at 10:57 am
With kids in the picture, considering the state of the economy, no, I don't think I would move to consulting at this time. Shifting jobs... Yeah, if the offer was...
"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 4, 2009 at 8:59 am
The first question I would ask is, do you really need 8000+ rows? You don't really have anything filtering the data down to human readable size. I'd push back on...
"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 4, 2009 at 8:54 am
You can get the TOP 5 by using the TOP key word:
SELECT TOP 5...
However, you need to order by something. Do you also have a call date? If so, you...
"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 4, 2009 at 7:53 am
Looking at the XML, the query is still showing up as a LEFT JOIN. This is straight out of the XML from the .sqlplan file:
LEFT OUTER JOINproject_securityproj_security


The optimizer swapped 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
February 4, 2009 at 7:46 am
I think you'd have to use CLR to create a sort for this. I've never done it, but if you perform a search, there is sample code available.
"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 4, 2009 at 7:13 am
sobhan.sb (2/3/2009)
[p]As i ran some DMV scripts to get server scope - Disk related IO information. I got the cumulative output like IO in MB and IO in Sec...
"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 4, 2009 at 7:10 am
I've used two different tools to do this. The one I've used the most is Quest Load Factory. You can combine with Quest Data Factory to create a large scale...
"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 4, 2009 at 6:54 am
Viewing 15 posts - 18,496 through 18,510 (of 22,226 total)