Joins are normally faster.

Try this link to find your answer

http://p2p.wrox.com/topic.asp?TOPIC_ID=9172 

Someone must have accidentally deleted the table. Just restore the table from backup and close the chapter. If this keep occuring then investigate

See the execution plan on both the server and see if you can see any difference

Check the order of transaction backup and compare with the full backup

I think Jeff brings a important point. Post as what you tend to do in the loop. If it is more than Print "Boy"

There are 2 issues

1. You are using varchar for comparision

2. THere is no begin and end. In that case only first line will execute for the loop

WHILE

...

We can argue on any solution for Audit. Whether to create a history table or create a generic table with information about only the data changed and do not worry...

oops. My query would just ignore the last 90 days

SELECT

Distinct Name

FROM

<TABLENAME>

WHERE

<DateField>