Just add an alias:

SELECT MAX( RowNumber ) FROM

(

SELECT

ROW_NUMBER() OVER (ORDER BY MSG_DTM_LASTSTATUSTIME DESC) as RowNumber

FROM

Message_MSG msg with(nolock)

) AS x

Can you use PowerShell instead? If so, I've got a good script I can point you to.

First thing I'd do is get the data model. Do you have a data modelling tool like ERStudio or ER/Win? If not, you'll have to use the built in model...

Thanks for the article Sarvesh. You may want to spend a little more time on the next one, just nail down why these things occur. As you showed, it's not...

DavidL (11/22/2010)

---

I've been trying to think of why exactly I feel these devices are oversold for many circumstances (I do not use one, but some on my team do, and...

Paul White NZ (11/23/2010)

---

GilaMonster (11/23/2010)

---

Anyone up for a challenge?

http://www.sqlservercentral.com/Forums/Topic1024140-360-1.aspx

I suspect the developer who said those can't be optimised doesn't know the meaning of the word. Dynamic SQL and lots of...

Some other potential optimizations. You have a whole bunch of DISTINCT operations. These are aggregates and when you see them everywhere in a query it's usually indicative of poor programming...

pavan_srirangam (11/22/2010)

---

Check isolation for snapshot isolation level which stores data in tempdb while retrieving data so that actual table can be updated with out lock any row locks will be...

What is this "down-time" of which you speak?

Craig Farrell (11/22/2010)

---

Grant, what about the option of using PAGELOCK as a table hint during the delete? If it's clustered on the ID, that'll keep it out of the...

Ah, well, you might be in trouble then. 1/3 to 1/2 of the table being deleted is likely to lead to table locks.

You might want to look at partitiioned...

3 million rows out of how many?

And again, an index alone won't necessarily do much for you, and could hurt you. What's the clustered index?

A lot of it also depends on your indexing architecture. Are you deleting based on the clustered index and, will those deletes take place in a different part of the...

That script isn't set up to run on 2000. You'll have to gather the metrics other ways.

Chris Morris-439714 (11/22/2010)

---

Our DBA caught some...