And yet again, I find out belatedly that I'm not quite usual/normal.

Never would have occured to me to go to a conference/whatever, without a specific goal and plan in mind....

Approximately how many rows does that table variable end up having in it when you run this?

pdanes (11/27/2012)

---

GSquared (11/27/2012)

---

pdanes (11/27/2012)

---

There doesn't seem to be any clear consensus on all this, so I guess I'll have to build a bunch of test cases and see what comes...

Search on this site is something Steve keeps mentioning and needing to be completely rebuilt.

I'm pretty sure most of us agree with him on that.

If the OS is 64-bit, then simply upgrading should do it. Test on a dev/test copy of the server first.

Generally, you run a trace (Extended Events in SQL 2008 or later) for a long time, to find that kind of thing.

After all, what if a stored procedure is only...

You don't need all the nodes. XML, by default, doesn't contain nodes with NULL values, so the engine just assumes those are NULL if they're missing.

Untyped XML can actually...

Is there an active Deny in place on that role accessing the second table or the schema it's in? That works differently than merely missing a permission.

Another alternative, create...

Virtualization can add to latency, especially with older versions.

Whether that's the situation you are running into is something that would take actually digging into the server to determine. It's...

pdanes (11/27/2012)

---

There doesn't seem to be any clear consensus on all this, so I guess I'll have to build a bunch of test cases and see what comes of it....

You need to change the sequence of WHEN statements in your Case. Whatever you want to override something else, you need to have the override value first.

So, move your...

adb2303 (11/27/2012)

---

I haven't, but only because I'm trying to mimic the behaviour of this 3rd party monitoring software. It uses ye olde style trace under the hood, and I'm...

Server responses to overwhelming amounts of network traffic are often unpredictable. That's why DDOS attacks are a favorite cyber-terror tool (like the "hacking" that Anonymous does, which is mainly...

I'd need to see the proc to be able to help out here.

Have you tried using Extended Events instead of an old-style trace? Does that do the same thing?