It checks to see if Anna_User has a schema first. That is still a step that can be avoided if you use schema.object qualifications.

You may not notice the performance hit...

Jeff Moden (5/12/2010)

---

I haven't checked the other versions of SQL Server but...

Sorry, I was out of the office and didn't get to respond until now.

What version of client tools is the workstation using? And did you say that you logged directly...

This article doesn't actually say the server *will* recompile the proc. It says it might.

Best Practice

It is best to owner qualify stored procedure names when you execute a procedure. This...

So far as I know, procs do NOT get recompiled just because you leave off the schema name in the EXEC statement, not even in 2000. I'd like to see...

I know of no way to only allow one connection via a login. Through the server properties, yes, but not on the login level.

However, you could give this person access...

Whisper9999 (5/12/2010)

---

Thx. I should have been a little more specific. What I mean is that we are seeing a "perfectly fine" query blocking, as in when you...

Server-side profiler trace is your best option to get all the data you want and not miss any logins.

Make sure to include the TextData field to get the procs and...

You are not off base. I/O is basically reads & writes to the hard drive. If your disk controller went whooey recently or if there's another problem bottlenecking your I/O,...

If I'm not mistaken, Data Mirroring uses the Service Broker to transmit data over to the mirror. So everything is queued up as messages that are read into the mirror....

Try this from different workstations and from the server directly. Do you still get the same error?

What edition & version (including service packs) of SQL Server are you using?

If someone asked me about the accuracy in an interview, my response would be "I don't know. I've never needed GetDate() or related functions to be that precise. If and...

GilaMonster (5/12/2010)

---

Same way you plan for any other scenario. Examine the risks, the chances of it happening, examine the...

Re-indexed as in recreated the ones that...

That seems to be an awfully low number of allocated pages. Did you run this after hours or during business hours?

Also, did you run it while the queries you...