if I have 30 items and agent runs every second - it will still take 30 seconds.  If I have 100 items - it will take 1.5 minutes.  If each...

I use the index for other queries as well. Can I create a new filtered index? How do I make the function use the new index? To...

Unfortunately, your suggestion is greek to me. Can you explain a bit more? And yes, it is killing performance.

Thank you.

Nope, our SAN is a the other one. We don't have SSD.

Mike

Thank you all.

I did a DBCC SQLPERF and found out that the log is only using .99% of the 700+ GB file. Later tonight, I will do a...

Yes, we are doing t-log backups every 24 min.

Also, I don't understand something about logging... doesn't a checkpoint command clear all dirty log issues? What is in a transaction...

Sean Lange (9/15/2015)

The main difference is that to use a computed column you would have...

What is the difference between using a view and creating a calculated virtual column?

Mike

We use the onorder to help in other areas of calculation like shipability - is the order shippable based upon current orders. That is why I am considering a...

Thank you for the info.

In your opinion, which is better - full every night or full once a week and differentials?

Mike

Yes, we store the total for the order. I have many small calculations that are done by the app. I want to move them to the DB but...

This solution will work great!

Thank you.

Work to put the log back to a normal size. 400+% is not normal.

Got it. It works!

Thank you!

Mike

I get the following error with the code from Ten Centeries:

Msg 515, Level 16, State 2, Line 1

Cannot insert the value NULL into column 'scancode', table 'Solovue_Homart.dbo.scancode'; column does not...