From BOL:

The minimum permission required is ALTER on table_name. TRUNCATE TABLE permissions default to the table owner, members of the sysadmin fixed server role, and the db_owner and db_ddladmin...

Wrong with it? No. If you have the bandwidth and the time then by all means you can run those nightly. However, if you have extra time do you mow...

41 ah, I remember 41. Let's see, that was...... oh yeah, this year for me too. 😉 Happy Birthday.

What would I like? A new acoustic guitar. Something mid-range, not...

Richard - If you can really split easily then that is going to be your quickest gain. Additionally, you will immediately split the IO which again is a bonus. The...

You will still have to do an update but something more dynamic. Ultimately you will need a scripting method for reading the contents of a folder. Check out the "Scripting...

Agreed with Gail, you can spread the load with replication effort but that has to be done very carefully and well architected. I have only seen a few environments where...

Based on what you submitted it looks like you need to do an update similar to the following;

update table1

set ref = 'your reference here'

where id = 123

If you are...

I used to have a great side-by-side comparison when I worked at another company where we supported both. Boy do I miss those days.... NOT!!! 🙂

After a bit of searching...

That depends on how your clients are going to be connecting to the instance. If you working with a fixed set of client connections within your firewall then CAL's should...

Is there application the only thing app hitting that database? If so, and they are confident that there will be no adverse affects then go for it. Make sure you...

Yes.

Can you post your tries so that we can help?

Have you updated stats on that table following the large data load? I have seen stats cause things to go out to lunch like that.

Agreed but it is one of those necessary oddities so that they can maintain proper releases to their customer community without forcing fixes on them that they don't want or...

Critical - If it is not a usable tool I am going to do something different or create something myself. So, being that I take such a strong stand, I...