Viewing 15 posts - 18,496 through 18,510 (of 22,219 total)
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
Is it possible that the different connections are changing the ANSI settings? That's the only thing that comes immediately to mind.
"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:53 am
For a bare-bones introduction to backups, check this out[/url].
"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:36 am
Huh. This sure sounds like what Profiler provides:
What is Code Coverage?
Code coverage measurement simply determines those statements in a body of code have been executed through a test run and...
"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:30 am
Christopher Stobbs (2/4/2009)
HI Grant,How do I check this: "You still need to look at I/O, CPU, execution time, wait states... " for the different operations in the query plan?
Basically turn...
"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 5:25 am
idrees.butt (2/3/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
February 3, 2009 at 1:37 pm
Steve Jones - Editor (2/3/2009)
a gee-whiz fiber optic laser beam assembler?:D
Standard model. She Who Must Be Obeyed makes me cut corners.
"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 3, 2009 at 1:34 pm
jungnaja (2/3/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
February 3, 2009 at 1:31 pm
Viewing 15 posts - 18,496 through 18,510 (of 22,219 total)