Saturday, March 23, 2013

TSQL Tips on Performance

I was researching some query performance tips and came across a great article by  called "The Seven Sins against TSQL Performance". I would strongly recommend reading over the article. I have outlined a few things that caught my attention.

  • Functions in Comparisons within the ON or WHERE Clause
  • Employing Multi-Statement User Defined Functions (UDFs)
  • Applying Query Hints indiscriminately
  • Indulging in Nested Views

Reference Link:


Post a Comment