Try this one: sys.dm_exec_requests

How big are the indexes and how fragmented? Small indexes won't usually benefit from defragmentation, so SQL Server will often just ignore you if you ask it to defrag...

Duplicate thread. Please post replies at active copy: http://www.sqlservercentral.com/Forums/Topic1377161-149-1.aspx?Update=1

Not just CPU from that SPID. Overall CPU use for the server. Can "hang" a query just waiting for CPU resources. Check what your wait-types are on...

Try this instead, see if it's any faster:

SET NOCOUNT ON;

IF OBJECT_ID(N'tempdb..#output') IS NOT NULL

DROP TABLE #output;

CREATE TABLE #output (line VARCHAR(255))

INSERT INTO #Output

VALUES ('<?xml...

To add some humor to it:

What happens if you run a dessert-oriented business, and you have tables Customers and Custards? Do they both get "cussed" at on their column...

Is the ID 58 going to be static in all of your data? If not, then the end-position is variable.

If it is static, then Stuff() will easily do what...

Server-side traces and extended events are how I do that kind of thing. You can capture any DML events you want to, and filter them pretty much however you...

That error means you have something in the Where clause that doesn't compare two things.

In the first copy, you have "= Securities.Quantity" after the Case statement. That makes it...

Periodic hardware over-use?

Really can't tell from what little you've posted. Not sure what you'd have to post to help. Sporadic, no-repro issues like that almost always require being...

Yes, I've seen it before. Was designed by a guy who got a PhD in Comp Sci in the '70s. He insisted that it had all kinds of...

I'm not clear on what you're asking. You need help rewriting the Case statement, but I'm not sure what you need it to do.

Ah. Yep, same name, different job.

I'm not accustomed to dev servers and QA servers needing any serious admin done on them, not enough to require a full-time employee for...

You posted the question in the...

winston Smith (10/25/2012)

---

GSquared (10/25/2012)

---

So far as I know...

So, try the query as-is and try with the index you want, and check a trace/extended events log, and see how long they...