From the error it sounds like the resource governor's enabled. What's the configuration for the internal resource pool?

Tony (3/10/2009)

---

I know that omitting an ORDER BY clause when using TOP 1 will return the first record found in the table. My question is, what is the “first...

Try starting the service from the service control app and then checking the error log file. Post the whole thign here if you're not sure how to interpret it.

and you can also check the login_time of session_id 1 in sys.dm_exec_sessions. Since the system sessions connect at startup and never disconnect, that will be the system start time.

Exactly the same way you do with a SQL login.

Updates that increase the size of the row

Database shrinks

Um, yes. The service is SQL...

If you have an audit trigger, check the Application_name() function. If you're using a trace to audit, check the application_name column

Sure. Any login, windows or SQL will only have access to the databases it's granted access to. If you don't grant access to a database the person using the login...

chrisau168 (3/10/2009)

---

Does that apply to me because in your post the NCI and CI must point to the same table with a nested join which does not seem to...

chrisau168 (3/10/2009)

---

But I would like to know how did you know the 28% was a key look up. To be it said clustered index seek doesnt that mean it...

DMVs don't store everything and they are not a replacement for SQL Trace.

On a busy server use a server-side trace rather than the profiler GUI. The trace has minimal...

Run profiler (or a server-side trace) for half an hour to an hour. Find the worst performing queries/procs...

Spam. Reported to mod. No replies please

thieuquanghuy (3/9/2009)

---

I replace FOR LOGIN_EVENT with FOR LOGON, but I have an error:

Msg 1084, Level 15, State 1, Procedure trg_LogonLog, Line 3

'LOGON' is an invalid event type.

I am very confused...