October 2009 - Posts

• Bad Habits to Kick: Using Alter Instead of Create to Look at Code

  It's a pretty common thing to right-click on a stored procedure, function, or view to look at the source code. Understand that I'm specifically limiting the scope to looking at the T-SQL code, not changing it. You have the option to script the procedure, Read More... Posted Wednesday, October 14, 2009 1:02 PM by John Paul Cook | 1 Comments

• SSMS Tips and Tricks: Scripting Inserts

  Sometimes you need to be able to script the loading of a table. SSIS and the Import/Export Wizard can do this, but there are times when you really need a complete set of insert statements. Red Gate’s SQL Data Compare or SQL Packager can do this, but not Read More... Posted Tuesday, October 13, 2009 10:03 PM by John Paul Cook | 0 Comments Filed under: Tips and Tricks, SQL Server 2008

• Bill of Materials - Where Used Query

  My post on indenting output from hierarchical queries showed how to do a parts explosion on a Bill of Materials (BOM) that was implemented with an adjacency list pattern. One very simple change converts the query from a parts explosion to a where used Read More... Posted Sunday, October 11, 2009 7:50 PM by John Paul Cook | 0 Comments Filed under: Bill of Materials

• Physical to Virtual Conversion – Disk2Vhd

  Disk2vhd is a new freeware tool from Microsoft you can use to do a P2V on a running physical machine. You can get it from here: http://technet.microsoft.com/en-us/sysinternals/ee656415.aspx . It doesn’t solve HAL problems. If you run into HAL problems Read More... Posted Friday, October 09, 2009 12:05 AM by John Paul Cook | 2 Comments

• Displaying Hierarchical Data - Indenting the Output

  When working with hierarchical data, people commonly request the output be indented for each level of the hierarchy. There are two key pieces to solving this query puzzle – knowing the level in the hierarchy and coming up with a sorting key for ordering Read More... Posted Saturday, October 03, 2009 11:49 PM by John Paul Cook | 0 Comments Filed under: Bill of Materials