Same syntax as an insert into a table that is not compressed. The CPU cost is minimal.

What driver are you using to connect to the informix database?

See if this article is of help.

http://jasonbrimhall.info/2010/07/23/a-little-dance-with-ssis-and-informix/

moroff phones:hehe:

Just grant them access to the Dev instance on the server rather than RDP. Then install management tools on their desktops and allow them to use SSMS to connect...

Seems very similar to another we had recently.

C6H12O6

Merge would be far better than SSIS for this.

+1. Good reference

A lower page fill can lead to improved performance.

High transaction, I might test as low as 70% fill factor but would be very cautious about it. You will need...

It's still there in 32 bit versions just not 64 bit Standard. I agree that it makes no sense.

Correct, it is not available in 64 bit versions

http://msdn.microsoft.com/en-us/library/cc645993.aspx

Maybe stand up a 32 bit version, use SSIS, or use Enterprise edition.

In addition, there are several good books you can get that will step you through various tasks.

One such is coming out next month

http://www.amazon.com/Server-2012-T-SQL-Recipes-Problem-Solution/dp/1430242000/ref=sr_1_3?ie=UTF8&qid=1342806921&sr=8-3&keywords=sql+2012+recipes

Pension

WayneS (7/19/2012)

---

The full backup will also contain the uncommitted transactions from transaction 4 at the time that the backup finishes. If a restore is necessary, the UNDO portion of the...

BenWard (7/19/2012)

---

paul.knibbs (7/19/2012)

---

How do you determine that without knowing the circumstances, though? They might have got a massive g-force spike because they were braking to avoid running into a jaywalking...