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...

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...

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 &#xA

The optimizer swapped the...

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.

sobhan.sb (2/3/2009)

---

Hi All,

[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...

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...

Is it possible that the different connections are changing the ANSI settings? That's the only thing that comes immediately to mind.

For a bare-bones introduction to backups, check this out[/url].

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...

Basically turn...

idrees.butt (2/3/2009)

---

Actually I have been working in writing SPs...so I dont think I should get a book that just tells syntax etc... I need to get insight of pros and...

Standard model. She Who Must Be Obeyed makes me cut corners.

jungnaja (2/3/2009)

---

I read about indexes from many forums and they are so confusing. I hope someone can help me by answering the following questions. I know some of...

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.

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.