I would agree triggers sound bad.

You have a process here, and you are storing data, not calculating on the fly, so likely there isn't something built into SQL Server for...

Trigger will fire for each batch update. So depending on how SSIS updates the tables, you might end up slowing the package.

If you have a datechanged for each row, you...

Pick up a copy of Inside SQL Server. One of those books has a great section on locking and lock escalation.

This help? http://blogs.msdn.com/b/sqlserverstorageengine/archive/2006/05/17/lock-escalation.aspx

The view is easier in terms of future development. It would be easy for someone to forget this in developing new procs, or you to miss one, and end up...

If it was recently, the default trace should capture this.

I don't see a place you're storing the profit. Is that correct?

If you aren't storing it, why do you need to calculate it after a load? Usually a client requests...

Or perhaps your log is just not sized correctly?

yes and no.

If you had

Begin Transaction

......

update x

update y

update x

....

This is one transaction. You can also have Implicit transactions turned on (http://msdn.microsoft.com/en-us/library/ms188317.aspx). If that's the case, then each statement starts a...

A couple questions:

Is tax specific (1:1) to a product and register? Or just a product? Meaning if I went to a different register could I potentially have different tax? If...

Which attribute/element are you looking for? Can you give a little more detail?

Does this help? http://www.lockergnome.com/sqlsquirrel/2008/05/23/how-to-turn-imported-xml-into-a-relational-format-in-sql-server-2005/

I think you might need to import this into a temp/staging table and then query...

It's not clear, and part of it is language. That's OK, but what I'm wondering, is how things are linked and what is the timing here.

Can you give an example,...

I completely agree, without support, there is no empowerment. I think management here should "guide" the employee with support, but also provide the check that this might not be worth...

You can also create a performance alert: http://www.databasejournal.com/features/mssql/article.php/1498781/SQL-Server-Agent---Creating-Performance-Condition-Alerts-on-Database-Server-Objects.htm

If you take something from a blog, please give credit to the source. Someone else wrote this, so ensure they get the credit...

I haven't seen this, but it looks like a CPU bottleneck. Do you have parallelism enabled (MAXDOP)? Is the CPU saturated when this occurs?

Log space cannot be reused until a transaction is committed and a checkpoint run. If you have one large transaction, it prevents reuse of the log file.

Setting to simple, do...