Last post Jan 18, 2012 07:13 AM by cnranasinghe
Dec 02, 2011 01:06 PM|mm8|LINK
Is there any official Microsoft guidelines stating that it is more efficient to write programatically more advanced business logic in C# rather than T-SQL?
If I for example want to parse a semi colon separated text file with say 20 columns and 100 000 rows and validate each of the values in the columns, e.g. check if some columns have valid data types, I guess the preferred way of doing this is in C#/VB.NET
rather than in a stored procedure or am I wrong?
Dec 02, 2011 01:15 PM|rkchaudary|LINK
yes, database is costly a resource. so you should not include your business logic in T-Sql.
it is so trivial that you can find this even in your company's "standards & guidelines".
sorry, i don't have any url to share.
Dec 02, 2011 01:54 PM|mm8|LINK
I am looking for some "proof" of this, perhaps a comparison of the performance or something.
Jan 18, 2012 07:13 AM|cnranasinghe|LINK
Hope you find some clues from following links