Microsoft® SQL Server 2005 Unleashed

Chapter 46. Transact-SQL Programming Guidelines, Tips, and Tricks

IN THIS CHAPTER

• General T-SQL Coding Recommendations

• General T-SQL Performance Recommendations

• T-SQL Tips and Tricks

One of the things you’ll discover with Transact-SQL (T-SQL) is that there are a number of different ways to write queries to get the same results, but some approaches are more efficient than others. This chapter provides some general guidelines and best practices for programming in the T-SQL language to ensure robust code and optimum performance. Along the way, it provides tips and tricks to help you solve various T-SQL problems as well.

Note

This chapter is not intended to be a comprehensive list of guidelines, tips, and tricks. The intent of this chapter is to provide ...