Dave does Data

Tutorials, Performance Tuning, Tips & Techniques on SQL Server & its ecosystem.

Browse by Tags

Tagged Content List
  • Blog Post: Tip SSMS: How to quickly find the line with the Syntax error

    When executing code in SQL Server Management Studio. Occasionally people make errors. If you find yourself counting thru your TSQL Batch up to “LINE 231” where your error is supposed to be, then this tip is for you.   Tip: Double Click on the Error message in the results pane. (In diagram below...
  • Blog Post: How to get Database Edition Power Tools to work on Visual Studio Team System 2008 Database Edition GDR

    If you want to compile sample code or write your own extensions for Visual Studio Team System 2008 Database Edition GDR (also known as DBPro or Datadude) this post will save you hours. Summary In Nov 08 when Microsoft shipped the GDR (General Distribution Release) for the Database Edition of VSTS . They...
  • Blog Post: Tip SSMS: Script your Entire Table including the Data – a hidden gem.

    Have you ever written a TSQL SELECT statement that builds INSERT Statements so you can script the entire table? Usually we do it to make it simple to create & load a “Reference or Lookup” table? Sure, Most DBA’s have. This Waay Cool little feature is buried in the options. You’ll never need to write...
  • Blog Post: Tip SSMS: How to BLOCK Select

    SQL Server Management Studio has so much capability, yet most people I meet don’t seem to have read the manual to discover it. So I thought I might post a few of features I find invaluable. This works for SQL 2005, SQL2008, SQL2008 R2 & Visual Studio. Summary: Tip 1: It is possible to “ALT + Select...
Page 1 of 1 (4 items)