I know this is an old post, but just want to add my two pence...

Select into a a good option as it is minimum logged. Also break up your...

Thank you for your posting, it is very helpful. Just want to point out when setting the return value of the function to the dataset parameter, it needs to...

I will suggest unit testing all the sp and udf (assuming you don't do much direct access to tables or views). This will ensure that you are only optimizing...