sadly SSIS variavles only go down to 1 second intevals.

one workaround to include milli-seconds is to convert the value to a Varchar and store this in a string variable and...

PeterG-377490 (7/28/2011)

---

Thank you Gail and SSCrazy for the advice.

As far as the additional request -

THere could be 5m rows

156 dates (3 yrs)

50,000 different items.

The query distribution is estimated at

1/3...

do you mean seconds (:59 ) or milliseconds as well (:59.000) ?

As Item_Num is not on the leading edge of your index, it could benefit from having an additional index added.

have a look at the Management Logs on SQL server, there will be an entry that will correspond to you access problem this will have a code that will...

ajsnyman (7/28/2011)

---

steveb. (7/28/2011)

---

ajsnyman (7/28/2011)

---

steveb. (7/28/2011)

---

ajsnyman (7/28/2011)

---

Each server will have its own SQL instance, but only one SQL instance will have the DB attached.

So when the primary server dies,...

ajsnyman (7/28/2011)

---

steveb. (7/28/2011)

---

ajsnyman (7/28/2011)

---

Each server will have its own SQL instance, but only one SQL instance will have the DB attached.

So when the primary server dies, so we can...

No, you can not create a trigger via t-sql for this.

ajsnyman (7/28/2011)

---

Jayanth_Kurup (7/28/2011)

---

Why not database mirroring ? its a high availability solution with automatic fail over ? i think it would work better for you than having to manually...

ajsnyman (7/28/2011)

---

Each server will have its own SQL instance, but only one SQL instance will have the DB attached.

So when the primary server dies, so we can just attach the...

I am not sure...

How would data get copied from one server to the other?

I think you would be better off dropping the custom idea, and simply implement database mirroring

Yes pretty much the second set of steps you outlined.

Insert data into a staging table,

then do a set based update based upon the primary key that joins them,

this...

There are a few ways of doing this,

one way is to write an update or delete statement in the ole destination and use this in the dataflow, ...

to scale our web application out (millions + hits a day) we designed one central database that held all the write information and then this data was replicated out to...