Browse by Tags

• backward compatibility
• best practices
• SQL Server 2008
• SSMS
• stored procedures
• T-SQL

• My stored procedure "best practices" checklist

  When developing stored procedures, there seems to be a lot of emphasis on "get it done fast." Which means type all lower case, pay little attention to formatting, and sometimes throw best practices out the window. Personally, I would rather front-load Read More... Posted Friday, October 31, 2008 7:40 AM from Aaron Bertrand | (Comments Off) Filed under: T-SQL, best practices, intellisense, stored procedures

• 2008 SSMS Query Editing Gem

  Hidden in the Edit > IntelliSense menu is QuickInfo, keyboard shortcut Ctrl-K, Ctrl-I. It pops up information (e.g. column name, data type, nullability) about the current object (table, view, DMV, column) under the cursor. Very Cool. Thank You to Buck Read More... Posted Friday, August 15, 2008 11:36 AM from Paul Nielsen | (Comments Off) Filed under: SSMS, intellisense

• Do you want IntelliSense to support SQL Server 2005?

  Currently, the plans for IntelliSense are to support SQL Server 2008 *ONLY*... since it works against SQL Server 2005 in the February CTP, I was very surprised to learn that it is being dropped by RTM (and possibly by RC0). This is mainly because of the Read More... Posted Tuesday, May 20, 2008 8:59 AM from Aaron Bertrand | (Comments Off) Filed under: SQL Server 2008, backward compatibility, intellisense