Viewing 15 posts - 76 through 90 (of 1,157 total)
MyDoggieJessie (2/18/2014)
February 19, 2014 at 2:40 am
MyDoggieJessie (2/18/2014)
MysteryJimbo (2/18/2014)
schleep (2/18/2014)
And on their wildest-dreams wishlist, they could schedule changes going to the destination days in advance.
As mentioned, merge replication can use dynamic dates to publish so this...
February 18, 2014 at 7:55 am
schleep (2/18/2014)
When you say, "Replication ALWAYS delivers data transactionally" do you mean in the same order as the changes were made in the source?
Yes. The order in which...
February 18, 2014 at 7:38 am
schleep (2/18/2014)
And on their wildest-dreams wishlist, they could schedule changes going to the destination days in advance.
As mentioned, merge replication can use dynamic dates to publish so this is very...
February 18, 2014 at 7:14 am
schleep (2/18/2014)
February 18, 2014 at 7:13 am
Lempster (2/18/2014)
February 18, 2014 at 4:28 am
This depends, is the user defined data dynamic or fixed?
Fixed is easy, just define your filters and its good to go.
If you don't have something you can use to filter...
February 18, 2014 at 2:59 am
Jake Shelton (2/13/2014)
MysteryJimbo (2/13/2014)
February 17, 2014 at 8:35 am
TheSQLGuru (2/13/2014)
such as transaction rollbacks.
Beat me to it.
If a transaction fails and rolls back, the identity is "lost". It isn't de-incremented as part of the roll back
February 13, 2014 at 9:11 am
I would consider a static temp table and if you wish, look at creating a dynamic pivot query.
February 13, 2014 at 9:08 am
Logshipping, Mirroring, Clustering and Replication (most people wouldn't use replication for HA) were all deemed High Availability technologies and provide a method of recovery using additional hardware.
There are a few...
February 13, 2014 at 7:32 am
Luis Cazares (2/12/2014)
You can still use DTS on 2008 if you want to have more time for migration. You can migrate DTS to SSIS in a phase 2.
This is correct...
February 13, 2014 at 6:30 am
I find it extremely strange that a migration should be estimated to take a week. With enough preparation you could have this done less than a day.
I have completed...
February 13, 2014 at 6:29 am
Jake Shelton (2/13/2014)
SQLRNNR (2/12/2014)
But why not apply those transaction log backups to the target as the backup occurs? You could logship those databases and keep them in...
February 13, 2014 at 6:26 am
yes, its called proportional fill.
http://support.microsoft.com/kb/328551/en-us
It may/may not massively improve the process.
90GB for a single process seems like a lot so you could potentially get better performance by reviewing the process.
February 12, 2014 at 4:07 am
Viewing 15 posts - 76 through 90 (of 1,157 total)