toddasd (6/22/2011)

---

Very nice club to have in the bag. Saved.

I had to qualify this part

FROM

...

matt.newman (6/22/2011)

---

In case this comes up for anyone else, truncate to the table msdb..sysjobstepslogs will clean up the space. Just was able to free up 36 GB after doing a...

vivekvinodhraj (6/22/2011)

---

yes i have created index and tried... still same problem...

And i dont know how to take graphical output... the zip file has trace file, and you can open using...

Brandie Tarvin (6/22/2011)

---

Meh. I've seen odder business decisions....

I can't even open the trace file (pre 2000).

And you can't post graphical execution plan so...

Convert the PK to clustered index and you'll be fine.

You didn't post the same query as in the original question. That query will always delete everything...

You didn't answer my question about the clustered index on that table!

It's easy when you type more than 3 words...

So you have no clustered index on that table?

We'll also need the actual execution plan of the slow delete to be able to debug this.

SELECT CASE WHEN LEFT(PhoneNo, 1) LIKE [0-9] THEN '0' ELSE '' END + PhoneNo FROM dbo.Table WHERE...

None of the system table are 100% accurate 100% of the time.

if you need an absolute exact count then you need to do count(*). But then again that number...

Nice script!!!

HowardW (6/21/2011)

---

LutzM (6/21/2011)

---

There might be a confusion between indexed views and "ordered" views.

In SS2K it's possible to control the order of the rows returned via ORDER BY in the view...

Where the heck did you read that? I've seen indexed views in 2K8!

james.morrison 19355 (6/20/2011)

---

You could just dump the results of SP_WHO2 to a table in a DBA database.

Run that in a job schedule for a week or two. Then search...