There is no need for a function. In fact, in this case it will even more slow down things as SQL Server processes functions rows by row AFAIK

I can do all kinds of neat stuff with it...Save files, word wrap, change the font, etc.   It has a nice GUI interface and great functionality.  You can store all...

Yes, some of the finest and smartest SQL guys around have given their input to that article.

As I don't know .Net yet. What is the outcome, Carl? No big difference in both alternatives as I suspected or something to watch out for?

Frank, your are the Omnipotent end user   It amazes me how people need their egos 🙂  I was talking to some DBA's a...

I think I agree with Frank on the numeric PK performance enhancements.  I think it just seems most obvious to visualize the rows in a numeric order, and then sort...

Seem to be my slow hours in the evening

Why are there then articles with a rating, Steve?

Unfortunately he is no member of SSC

Not quite sure if I understand you, but I guess the answer is NO. Parameter values of a stored procedure can be retrieved by using the OUTPUT keyword as explained...

Although he mailed you directly, Carl, I'm posting the answer from Erland here for the community to enjoy:

>But I still have a question:

>Is there a difference (in term of...

Hey, does anybody remember the famous 'Do certification add value' thread several month ago?

Hey SQLBill, how did you do this formatting. Do the 'old' code tags work still?

Brian Kelley has a nice article on normalization http://www.sqlservercentral.com/columnists/bkelley/normalization.asp

As has been said above, there are no arrays in SQL Server available. However you might get some ideas here http://www.sommarskog.se/arrays-in-sql.html

ok, so a Primary Key could be something like 'bmw' or 'ford' in a 'mfr_name' column in a table called 'vehicle_mfr' as long as the manufacturer was only in the...