1.) I have a 20 billion byte table in SQL 2005. I will be deleting about 1/3 of the rows in the table. When I perform these deletions, can i temporarily stop from writing to the log file by setting the backup to SIMPLE or if I do this am i asking for trouble by switching from FULL to SIMPLE and back again to FULL. I assume I should do a full backup, switch to SIMPLE, perform my deletions, then switch back to FULL backup?
2. ) What gets written to the Log file when you delete an index from a table?
3.) I was told to delete non clustered indexes first, then the clustered index?