Why not do a delete first?

That's not where I'd start but I guess you're way down on the rabbit whole?

Any proof of memory pressure or io read issues? If not I probably wouldn't waste...

Same...

#1 Select rank

#2 Use #1 as cte or derived table (not sub query)

#3 Apply filter THEN only on studentid

#4 Move on to next task

Ninja FINALLY overtakes Lowell!

:-D:w00t::cool:

Then insert both columns, or join on the name. Assuming they actually match.

GilaMonster (9/20/2011)

---

uncle_boris (9/19/2011)

---

2. The report also mentioned doing the same for the TempDB log files. I have read that unless the max size of a log file is going to...

Well you need a group on year for the columns

and a group for recipient on rows.

Then the data is sum(whatever).

This assume that you didn't pivot the data sql server side.

If...

sp_send_dbmail

can send an e-mail (scheduled via job).

You can send file or attach the results of a query as file.

drew.allen (9/20/2011)

---

Isn't...

Error #?

What were you doing when it happened?

Anything usefull in the logs?

Nice use of a short-circuit!

Then you just have to find a way to remove the rtrim in the where clause and this then has a chance to fly!

You need to join on something.

Right now you are doing a cross join and basically putting a random guid in the update.

What's commun in both tables you can join on?

tfifield (9/20/2011)

---

Well, everything worked fine thanks to Gail. However, when we were restoring the logs we stopped one short of where we really wanted to be and then did...

No your problem is that you ask for help and are not willing to give us what we need to give you...