Since functions are not pre-compiled, is there any performance gain from using user-defined functions as opposed to stored procedures? - 17 Oct 2006

I would like some input on the best, most efficient way to store images for use on a website. - 17 Oct 2006

Can you provide some ways that I might be able to avoid using cursors in my applications? - 17 Oct 2006

Can the use of NULLS in a database affect performance? - 17 Oct 2006

In my stored procedures I have the option of calling the same data from either a table or a view. For best performance, should I be calling a table or a view? - 17 Oct 2006

I don’t like to delete records in our production database, even though we will never need them again. Does this affect performance? - 17 Oct 2006

Should I use the old Microsoft JOIN syntax, or the ANSI JOIN syntax for the best JOIN performance? - 17 Oct 2006

Is is more efficient to use SELECT DISTINCT or GROUP BY to perform the same function? - 17 Oct 2006

My application makes heavy use of temp tables. Should I be creating temp tables as needed, or should I be using a permanent table over and over instead? - 17 Oct 2006

Which is faster when using SQL Server 2000 or 2005, temp tables or the table datatype? - 17 Oct 2006