"One size fits all" could work if it applies in both directions. We are currently in the process of replacing a bespoke system with a package. The bespoke system allows...

I agree with the use of stored procedures for all the reasons mentioned in the article and, because I was on the standards committee, managed to get this included in...

As you now know the application is hitting a timeout, you could set the timeout on the SQL command to a higher value than the default (30 seconds). In C#...

From what I remember (it's been a while), C# treats all SQL date datatypes as its own DateTime type and you have to specify the display format in the data...

I'm doing a major implementation of cross-platform changes this evening - tempting fate?

Depending on the product used for the presentation layer, you may find the column names will be prettified automatically. We use DevExpress and it separates the words in a CamelCase...

As an aside, I'm pretty sure you won't want the amount to be FLOAT as this will not give exact results in calculations.

One other thing to be aware of is that EXCEPT eliminates duplicates.

You were asking how to do something and I was suggesting some ways of making it work. I don't see how that is belittling.

I don't think using the transaction name to determine which action to take is the right model. Your application already knows whether the user intends to insert, update or delete...

In your database, create a user-defined table type that matches the columns in "myorder". Your stored procedure can then specify a parameter that uses this table type instead of one...

Not an explanation of your problem, but in our warehouse we tend to drop indexes then truncate/load then recreate the indexes. It is generally a lot quicker on low-spec servers...

Regarding your 2nd question "should I worry about it", I'd say it's definitely worth giving them sensible names if you have copies of the database for development, QA, etc. and...