Is it true that before sqlserver 2005 you cannot specify optimizer hints for insert update and delete statements ?

How do we specify a hint for a delete statement to use a particular index while deleting records

Is there any sample T-sql proc that can delete records in batches from a table in sql server

Whats the fastest way to delete records from table in sqlserver assuming i need to delete millions of records from a billion records table