Rolling back SELECT query taking hours, using high CPU and very low disk. Cannot diagnose cause.

SQLServerCentral » Latest topics

Rolling back SELECT query taking hours, using high CPU and very low disk. Cannot diagnose cause.

A user has ran the below command against one of our production servers (table name and ID value substituted). This is the complete problem query.

[code language="sql"]SELECT DATA.ID
FROM (
  S

more info...