Southwest Fox 2008 - Day 1

by Frank Perez October 16, 2008

Today began with Andy Kramek's pre-conference session - Introduction to Transact SQL. This session covered the basics of Microsoft SQL Server Transact SQL (T-SQL). From variables, temporary tables, and common table expressions. To functions, stored procedures, triggers, and more.

My favorite part was the explanation of how Microsoft SQL Server, and most other database management systems, process a SELECT command. Andy took us step by step how the query engine builds each of the intermediate result sets, the order everything is processed in, and how Visual FoxPro's engine works slightly different.

Knowing this helps me understand how to build better SELECT commands. It also explains why a SELECT command might not always do what I expect it to. Great information.

Keywords:

Filed Under: VFP

Comments are closed

About Frank

Frank lives in West Bloomfield, Michigan with his wife and three children.  When he is not writing code, he enjoys long distance running and riding his motorcycle.

Month List

Tag Cloud