I do not have much knowledge of using SQLCLR or OPENQUERY other than linked servers. Mentioned below is one of my requirement can someone please provide me the actual query...

Grant Fritchey (1/26/2011)

---

sqldba_icon (1/26/2011)

---

I really always ask this question to my self. If there is a native tool like perfmon to capture all the data why do people spend $$$...

Mike - CI (1/26/2011)

---

SSIS seems to be as good an alternative to linked servers as anything, since you can have multiple datasets from differing sources.

Openrowset if you have...

This is just from my past experience. If you are on a 64 bit box and using a linked server for your process i have noticed big delays one of...

I really always ask this question to my self. If there is a native tool like perfmon to capture all the data why do people spend $$$ on third party...

thanks.

what would be the best way to find slowest query in a batch. One taking most time

Thanks..Is there a way to calculate total cache used over span of 8 hours?

thanks..let me try.

Eric M Russell (1/24/2011)

---

sqldba_icon (1/20/2011)

---

... I have a procedure when it is executed for the first time takes about 25 secs and 2 secs from there onwards. Now from the...

arussell_10 (1/24/2011)

---

Thanks all!

I was originally worried I would install SP3 and Security update (.4053) and think I got everything. However, there would have been an additional CU...

I have filter on trace for a...

GilaMonster (1/23/2011)

---

You're testing on a dev or test...

GilaMonster (1/23/2011)

---

Are you checking the object_id in the right database? Object_id is just to identify the procedure and, if you have the text you already know what the procedure is....

i was able to generate execution plan using Show XML Statistics Profile,however the execution plan from management studio is little from the execution plan captured in trace. Any idea?