Chris Morris (2/13/2009)

---

This poster's been active for a couple of years...quite a few of his posts...

Bruce W Cassidy (2/12/2009)

---

Roy Ernest (2/11/2009)

---

One thing I have seen is that Unix (Linux or Sco or what ever) has a better File system. This made Oracle much faster when...

You can also check how much RAM the SQL Server is using.

Grant Fritchey (2/12/2009)

---

GilaMonster (2/12/2009)

---

Eeep..

http://www.sqlservercentral.com/Forums/FindPost655667.aspx

I want to do a PhD in the area of database optimisers. Can anyone suggest a good topic?

Gees, it took me months of reading to decide on...

The only thing is that since everything is GUI, The developers think that there is no need for a DBA since they can do it by themselves. Also you see...

Actually it depends on your DB design.

For instance you have an Identity column in the publisher, The subscriber will not be an identity column. It will either be an int...

That was a pretty good one. He gives the obvious answer and still ask the question.. 😀

I like to help, but I am very very bad at explaining. I usually...

We tried it between two continents. The latency was about 360ms. Even synching the DB initially was a problem. And then sometimes the Internet connection dropped.

Jim C (2/11/2009)

---

Roy, while i agree that the solution you're talking about would work, why spend the time designing a replication-like technology from scratch when SQL server includes replication at...

First you write triggers that fires when your App (or even updates made by you on the fly) makes any changes to the data in the tables. This trigger will...

You can always write a trigger on the tables that will fire After Update, Insert or delete and write to another table with a Primary key, Table name and operation......

For what I am saying, you will need to tag any transaction that happens with what kind of operation it was. (Update, insert and delete).

Ah... Windows Server 2008. 🙂 Thats a different ball game all together. I would wait for cpouple of Service pack to come out before I move into it. 😛

You will...

There is only one option to do it. That is drop the table from Replication and then add it after the alter commands are done.

To add it there are two...

Friday the Thirteenth.... My lucky day..:D