O'Reilly logo

SQL Server MVP Deep Dives Vol. 2 by Kimberly Tripp, Paul Randal, Paul Nielsen, Brad McGehee, Greg Low, Louis Davidson, Kalen Delaney

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 19. T-SQL: bad habits to kick

Aaron Bertrand

As a longtime participant in the SQL Server community, I’ve seen my share of bad habits. I’ve even formed a few of my own, all of which I’m on the path to correcting. Whether they come from StackOverflow, the MSDN forums, or even from the #sqlhelp hash tag on Twitter, one thing is clear: bad habits can spread like poison ivy. The same is definitely true in Transact-SQL (T-SQL), where samples are borrowed, reused, and learned from on a daily basis.

Many people think SELECT * is okay because it’s easy, or that following coding standards for this one stored procedure is unimportant because it needs to be deployed in a rush, or that they shouldn’t have to type that ORDER BY statement because ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required