If the user is currently not logged in you can use a LOGON trigger and write the HOST_NAME() and APP_NAME() information into a table.

I confirm Luke. A linear behavior seems to be well in my opinion.

Anyway, 20ms seems to be a not a good performance (sure, depending on the hardware). I'm quiet sure...

Yep. I also just figured out. Works also in combination with TOP. It is the parser tolerance to allow missing spaces between numbers and aliases:

SELECT TOP 100N FROM Tally

That's also...

Grant Fritchey (5/20/2009)

Hey! Don't laugh at me. Just tell me what it is.

I'm starting to feel like Earl in Tremors:

"Hell Earl, everyone knows all about these things....

This really seems to be an unwanted feature. A CONVERT also doesn't work:

SELECT

CONVERT(INT, 1).Blah

rofl!!!

Nice article, Chris!

Now we have an un-drop. Last things we need are un-delete and un-update. 😀

(I know about auditing tables ;-))

Is "password expiration" configured for your SA login?

Wow. That's a bunch of signature! 😀

Hi justanewone

Nice trick! Never saw a PARTITION BY NULL!

Kiran,

I don't think that the error was raised by the code you posted. The error says that you cannot implicit convert from NTEXT to VARCHAR. The implicit convert from VARCHAR...

Glad that I could help!

Hi Tim

I took Lowells advice to use a tally table based solution in a nested style (first seen from Bob).

@Lowell:

Thanks for the test data!

This should work. I just don't know...

Hi Eswin

Your query works with the braces around the joined table names? I get a syntax error on my system. I removed them and now it works (parse).

I think you...

Hi Hans

Did you check the activity monitor for some jobs with higher load? Are there some special tasks/statements which cause the high load?

Did you check the count of CPUs configured...