Catálogo de publicaciones - libros

So we are coming toward the end of the book, and you are well primed with T-SQL knowledge of what you can achieve within stored procedures and functions. In Chapter 13, we take a look at triggers, and all you have learned with programming T-SQL can also be applied there as well.

Subqueries are one of the most commonly used areas of T-SQL, but common table expressions are also useful, so knowing these areas well will enable you to move forward at a rapid pace. Combine this knowledge with the functionality covered in Chapter 11, especially when working with JOINs, and you should start to see how powerful T-SQL can be at working with time-based data.

One last piece of advice: if a query starts becoming very complex, you may find that it starts performing badly. We don’t look at performance of queries within this book, although we have discussed indexes and how they can help your query perform better. Always take a step back and think, “Would this work better as two queries where the first query creates a subset of data?” Writing the most complex of queries that processes all the data in one pass of the data may not always be the best answer.

So we are coming toward the end of the book, and you are well primed with T-SQL knowledge of what you can achieve within stored procedures and functions. In Chapter 13, we take a look at triggers, and all you have learned with programming T-SQL can also be applied there as well.

Subqueries are one of the most commonly used areas of T-SQL, but common table expressions are also useful, so knowing these areas well will enable you to move forward at a rapid pace. Combine this knowledge with the functionality covered in Chapter 11, especially when working with JOINs, and you should start to see how powerful T-SQL can be at working with time-based data.

One last piece of advice: if a query starts becoming very complex, you may find that it starts performing badly. We don’t look at performance of queries within this book, although we have discussed indexes and how they can help your query perform better. Always take a step back and think, “Would this work better as two queries where the first query creates a subset of data?” Writing the most complex of queries that processes all the data in one pass of the data may not always be the best answer.

So we are coming toward the end of the book, and you are well primed with T-SQL knowledge of what you can achieve within stored procedures and functions. In Chapter 13, we take a look at triggers, and all you have learned with programming T-SQL can also be applied there as well.

Subqueries are one of the most commonly used areas of T-SQL, but common table expressions are also useful, so knowing these areas well will enable you to move forward at a rapid pace. Combine this knowledge with the functionality covered in Chapter 11, especially when working with JOINs, and you should start to see how powerful T-SQL can be at working with time-based data.

One last piece of advice: if a query starts becoming very complex, you may find that it starts performing badly. We don’t look at performance of queries within this book, although we have discussed indexes and how they can help your query perform better. Always take a step back and think, “Would this work better as two queries where the first query creates a subset of data?” Writing the most complex of queries that processes all the data in one pass of the data may not always be the best answer.

So we are coming toward the end of the book, and you are well primed with T-SQL knowledge of what you can achieve within stored procedures and functions. In Chapter 13, we take a look at triggers, and all you have learned with programming T-SQL can also be applied there as well.

Subqueries are one of the most commonly used areas of T-SQL, but common table expressions are also useful, so knowing these areas well will enable you to move forward at a rapid pace. Combine this knowledge with the functionality covered in Chapter 11, especially when working with JOINs, and you should start to see how powerful T-SQL can be at working with time-based data.

One last piece of advice: if a query starts becoming very complex, you may find that it starts performing badly. We don’t look at performance of queries within this book, although we have discussed indexes and how they can help your query perform better. Always take a step back and think, “Would this work better as two queries where the first query creates a subset of data?” Writing the most complex of queries that processes all the data in one pass of the data may not always be the best answer.