Friday, January 8, 2010

Noob Misinformation upon migration from Access to SQL Server

In access using a single table for getting complicated queries , it is not uncommon to see loads of temporary queries.
However in SQL server you have the feature of "Derived tables" which are basically SQL Selects embedded / named and reused in a larger query. You can still use views ( Stored queries in SQL Server) for performance benefits but to keep things clean don't make too many views if they are just going to be a part of some cooler query and you think that views help understand better. They don't (generally they just get cluttered) and derived tables are so much cooler :).

Sql query inside an sql query for peace of mind :)  and you know immediately how its being used.

Read more here :
http://www.sql-server-performance.com/articles/per/derived_temp_tables_p1.aspx
http://www.mssqltips.com/tip.asp?tip=1042

Enjoy!.