Originally posted here. 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 parameters.''  I've run into this assertion before, and ...

Originally posted here. 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. There was a little discussion on SQLTeam about the best ...

Originally posted here. 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. [sic]'' Before reading any further, I ask that ...