Browse by Tags

• Performance
• T-SQL

• Stored procedures are not parameterized views

  Peter van Ooijen over at CodeBetter.com posted in his blog about some observations he had when working with stored procedures in a recent project . What I found to be interesting about his post was his comment that a stored procedure can be, "a view with Read More... Posted Wednesday, July 12, 2006 10:54 PM by Adam Machanic | 6 Comments Filed under: Architecture, T-SQL

• Rowset string concatenation: Which method is best?

  Yeah, yeah, yeah, let's get this out of the way right from the start: Don't concatenate rows into delimited strings in SQL Server. Do it client side. Except if you really have to create delimited strings in SQL Server. In which case you should read on. Read More... Posted Wednesday, July 12, 2006 10:15 PM by Adam Machanic | 25 Comments Filed under: Architecture, Performance, T-SQL

• No, stored procedures are NOT bad

  I recently found a rather old post from Frans Bouma 's blog, "Stored procedures are bad, m'key?" . Since comments are closed (he posted it almost a year ago), I have to reply here. I'll state my bottom line at the top: Stored procedures are not only not Read More... Posted Wednesday, July 12, 2006 10:10 PM by Adam Machanic | 10 Comments Filed under: Architecture

• Caveats of the TEXT datatype

  Someone named "Krygim" posted the following question today in the microsoft.public.sqlserver.programming newsgroup: "Will defaulting a TEXT field to an empty string take up more space than defaulting it to Null when no data is entered into the field. Read More... Posted Wednesday, July 12, 2006 10:02 PM by Adam Machanic | 0 Comments Filed under: Architecture, T-SQL