Browse by Tags

• T-SQL
• XML

• Multiple-Valued Parameters

  So I was doing some research on which is the best way to pass multiple-valued parameters into a stored procedure or user-defined function when I found some interesting results. I had always used a string-based user-defined function to parse a delimited Read More... Posted Monday, February 12, 2007 4:43 PM by Peter W. DeBetta | 19 Comments Filed under: T-SQL, XML, Performance

• Medians, Actual Query Cost, and Statistics

  I was going to comment on Adam's post " Medians, ROW_NUMBERs, and performance " (which was a follow-up to Aaron's post " Take the high road to middle ground ") and I realized that I needed to show some code and alas, comments are not so nice about formatting Read More... Posted Wednesday, December 20, 2006 5:48 AM by Peter W. DeBetta | 2 Comments Filed under: T-SQL, Performance