Viewing 15 posts - 18,481 through 18,495 (of 22,202 total)
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...
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...
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...
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.
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...
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...
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.
February 4, 2009 at 6:53 am
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...
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...
February 4, 2009 at 5:25 am
idrees.butt (2/3/2009)
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.
February 3, 2009 at 1:34 pm
jungnaja (2/3/2009)
February 3, 2009 at 1:31 pm
I'd start with Itzik's book. It'll get you going. As you've seen, there's tons more out there, but you have to start somewhere.
February 3, 2009 at 1:21 pm
And apparently I'm no longer able to work the link buttony thing... If only it were a fiber optic laser beam assembler... I'd be fine.
February 3, 2009 at 1:18 pm
Viewing 15 posts - 18,481 through 18,495 (of 22,202 total)