I don't see how performance could be improved by using an application solution. SQL is already set-based as can insert, update, and delete anything from the Xml you send...

Yes. I'm not sure what the best approach is (hence why we have this thread going). You may be able to put your database back to "latin" and...

Most applications attempt to do this by having a single "NVARCHAR" column for FirstName, LastName, etc. This post is just about storing that information in a more efficient manner....

About the whole row count issue. I know this isn't bullet proof but SQL is already tracking the row counts in every table. You don't need to create...

thierry.vandurme (1/6/2009)

---

I don't really understand how this reduces server resource utilization except for network traffic. If a user is paging through the data screen, only a screen full of rows...

Without going into too much detail, using configuration files in this manner is one of the basics and you can probably find a lot of help online or in the...

This is a very interesting technique. I am using CONTEXT_INFO to set the current "ClientContext" that is executing any Procedures from an Application. This allows me to track...

Well, yes, I also wish MS would have just allowed us to specify a culture code. There are two functions @@LANGID and @@LANGUAGE. These will show you what...

I'm not seeing these Functions in SQL anywhere...

If you're talking about "partial" classes, yes, I am aware of that. LINQ generates all the class definitions as "partial" classes so you can simply add extra files. ...

Just a word of warning. This all looks good at first, but you will find it largely unmaintainable in the future. Having to constantly regenerate "wrappers" for all...

LINQ does do this. There are 3 flavors of LINQ (LINQ to SQL, LINQ to Objects, and LINQ to Entities (i.e. for ADO.NET)). If you hook up SQL...

First off, good job. I am starting to see this a lot, my company does something similar where they just make strongly-typed Stored Procedure classes. I've actually had...

Thanks for the comments (love it Jeff). I agree that accounting would be a different scenario, heck, maybe even storing an OrderAdjustments table where you have an AdjustmentType (SalesTaxState,...

True, sorry, my Accounting knowledge is only so-so 🙂