THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » bad habits » performance   (RSS)
  • Bad Habits to Kick : Using EXEC() instead of sp_executesql

    Today in my T-SQL: Bad Habits to Kick session at SQL Saturday #84 in Kalamazoo, a user asked if SQL Server supported anything like bind variables in Oracle when using dynamic SQL. When using dynamic SQL, you have two choices: EXEC() / EXECUTE(), or sp_executesql. Early on my career, I used EXEC() a lot, because it was much easier. I've since ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on September 17, 2011
  • T-SQL Tuesday #20 : T-SQL Best Practices

    T-SQL Tuesday, the invention of Adam Machanic (@AdamMachanic), is what he calls a recurring, revolving blog party. Each month, a new host picks a topic, invites bloggers of all levels to join in, and then after all the submissions are in, writes a summary of all of the entries. This encourages people to participate in the community more ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on July 12, 2011
Privacy Statement