Transact-SQL

@ Database developers must hava a thorough knowledge of Transact-SQL to read data from and write data to SQL Server database. Using Transact-SQL is the only way to work with the data.

@ Transact-SQL is a fairly simple language; Yet many develpers don't spend the time to understand it, and they end up writing less-than-desirable code.
@ The key to creating well-perfomring Transact-SQL queries is to think in terms of sets instead of row-by-row operations, as you would be in a procedural system.

@ A database developer must ensure that queryies use as few tables as possible to statify the data requirements.

@ Avoid the temptation of creating monolithic, do-everything queries that can be sued to statisfy the requirements of many different parts of the applicaton, or that return data from additional tables just in case it might be necessary in the future.