Chris Howarth-536003 (5/12/2010)

---

This makes an interesting read, particularly regarding SQL 2005 SP3's attempts to lower granularity to 1ms, but the article doesn't specifically mention GETDATE():

[url=During startup SQL Server attempts to...

Now I am really puzzled.

Well, the whole thing has to do with the OS timer. When I bumped into the 16 ms precision of getdate() over a year ago...

SQLZ (5/12/2010)

---

I get 3.3 ms here using your own code.

The worst part about it is you would have not given the job to someone who correctly responded with 3.3ms for...

Wow.

I did not expect to get so many posts before I even show up for work.

Looking at all the replies, one potential explanation for some of the 'better'...

Software is like a Cathedral. You build it… you build it… you build it…

And then you pray…

Jeff Moden (4/12/2010)

---

I think that the code that uses the table and the design of the database needs serious review once it's moved. Perhaps the parental lineage of the...

Try this:

SELECT B.GroupName

FROM test A

INNER JOIN test B ON A.FieldName = B.FieldName

AND A.FieldValue = B.FieldValue

AND A.GroupName <> B.GroupName

WHERE A.GroupName = 'Group1'

AND B.GroupName NOT IN (

SELECT B.GroupName

FROM test A

RIGHT OUTER JOIN...

1. To send MSMQ messages (originally it was a SQL2000 extended SP written in C)

2. SQL Server could't do it natively.

3. Yes

4. Accessing resources not available directly to SQL Server....

Many years ago I had similar problem with SQL Server 7. After installing SP3 the application using the server basically stopped to work. The response times were so slow the...

itskumar2004 (12/2/2009)

---

well i have been told to do that with existing scripts(by just replacing the table names ) which are stored with .cmd extension in a folder .when i...

Unfortunately this is the trend - keep packing more stuff into the tools - so you can keep selling them over and over again. If you create something that works...

To stop the trace use sp_trace_setstatus @traceID, 0

To delete the trace definition use sp_trace_setstatus @traceID, 2

The @traceID is the ID you got when you run the code provided in the...

G33kKahuna (12/2/2009)

---

Jacek, Giving you a hard time was not my intention. When you post an article with a title "Using Server Side Traces for Dynamic Performance Evaluation" but offer up...

TheSQLGuru (12/1/2009)

---

Well done.

I have been doing this type of analysis for a decade now, but have never done the execution histogram like you have done with the case...

Tommy,

Thanks for stepping in in defence of the article. I am very pleased someone found it useful.

Fortunately this is an open forum so everyone can express their opinions. It happens...