I have a few ASP.Net 2.0 Data Caching / SQL Server 2k related questions...

* If a SQL Server 2k table is enabled for .NET 2.0 data caching
notifications but the table needs to be dropped and re-created each
night will the sql data caching be deleted with the table when it is
dropped or will it stay in place and work on a new table we re-create
each night with the same table name and structure as the one we
dropped?

* Will SQL Data caching on a table slow the import of a large CSV file
into that table? If so, can it be deactivated temporarily? We insert
close to a million rows nightly and do not want to slow it down with
caching though we need the caching later on for the web interface.

* If you have created an index on a table and then rename the table
does the index need to be re-created under the new table name?

* If you have a nvarchar(1000) field in a database of product names
with roughly 1,000,000 records and need to perform wildcard queries on
the field such as "Select * From TABLE where PRODUCTNAME LIKE
'jumbo%'" is there anyway to speed this type of query up?