DeanGC questions

DeanGC answers

• Eliminate queries with a temporary table that get update every x minutes
• What are the downsides of creating SQL Server stored procedures in the following manner?
• Is it good to create a nonclustered index on a column of type varchar?