Research indexBook chapter
Execution Plans
Noble
Apress eBooks1 Jan 2020
NobleIDark:/48914/w1/20260521/7F3B4DD8DOI10.1007/978-1-4842-5590-2_7
Execution Plans
Noble · Apress eBooks · 2020 · Subscription
NobleIDark:/48914/w1/20260521/7F3B4DD8DOI10.1007/978-1-4842-5590-2_7
The full text is at the publisher
You can read the abstract here, or open it at the publisher.
Abstract
When I first started writing T-SQL, I focused on using the right syntax. I worked to try memorizing things like if the GROUP BY clause came before the ORDER BY clause. As I became more familiar with writing T-SQL, I had new challenges like making sure that my results were accurate. Over time, I got to the point that not only was I writing queries with complex logic, I also had to write several simpler queries to verify my results. I got to the point where I started debugging T-SQL code that had been written by other database developers. I also became responsible for researching various application issues.