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 » Performance » bad habits   (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
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement