http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

You can't use group by in an update.

You have to precompile the data in a derived table and then join back to the base table for the update.

Start with this. It should shed a lot of light (if not all of it) on what's wrong with your code.

http://www.simple-talk.com/sql/t-sql-programming/rbar--row-by-agonizing-row/

Assuming it's not a global temp table, then you'll have to kill the spid that holds the table alive.

Once the connection closes, the temp table will self destruct.

Hey Jessica, I've just been tasked to make all our reports work on iphones. Any hints on how I can accomplish this?

The users will need to access an interface to...

Ian Scarlett (2/16/2011)

---

I also thought that if you executed a procedure on a connection with implicit...

GilaMonster (2/16/2011)

---

If implicit transactions are on, the transaction begins when the first statement/modification occurs (I'm not sure which) and commits when an explicit COMMIT TRANSACTION statement runs. All that implicit...

Lowell (2/16/2011)

---

remember a TOP without order by doesn't make sense...

to do the top 20 of the top 90%, it's just nested selects....

select TOP 20 * FROM

(

SELECT TOP 90 PERCENT *...

Exactly... simple way to solve the problem!

Why can't you do all of the processing in 1 batch (create, populate, select, drop)?

Paula-196779 (2/15/2011)

---

I realise this but there seems to be a problem with SQL Server (known it would seem if you google around) where sometimes and as far as I can...

GilaMonster (2/14/2011)

---

If that was the only error that the integrity check maintenance task picked up, then there's no need. That...

Ok then, what she said (she's much better than I at this).

But...

I'd go 1 step further. I'd run checkdb as soon as possible.

There are errors missed in 2000 that are detected in 2005.

Make sure you have a valid backup as...

I don't see anything for sql 4, 5... would be a nice historical research!

BTW congrats on the shortest article ever!