Incorrect. You do not. There few...

mick burden (3/21/2014)

---

Hi everyone, does anyone know if it's possible to update 2 tables that reside on 2 different servers from within one SP? I have access to 2 servers...

alhajirr (3/20/2014)

---

I have a Distributor server and a Subscriber server that is live and replicating. However, they are not part of a cluster. We recently decided to add...

Also worth pointing out that I remember switching to queued updating because of performance problems when using updateable subscriptions. The cross network traffic wasn't keeping up.

humbleDBA (3/20/2014)

---

It is 'true' replication as it uses Transactional Replication. The main difference is that when the subscriber updates, it makes use mechanism to re-direct the subscriber update to...

I've used this before as...

This will only work if its new storage AND a...

Both those approaches take time. Personally I would opt for backup/restore ensuring the backup is appropriately located for a fast restore. This would allow for a recovery option...

http://www.mssqltips.com/sqlservertip/2494/overview-of-peertopeer-transactional-replication-in-sql-server-2008/[/url]

http://technet.microsoft.com/en-us/library/ms152536(v=sql.105).aspx

http://blogs.msdn.com/b/repltalk/archive/2010/02/16/walkthrough-setting-up-sql-2008-peer-2-peer-replication.aspx

http://www.sqlskills.com/blogs/paul/sql-server-2008-configuring-peer-to-peer-replication/[/url]

This depends on your definition of bi-directional. If the website is writing to unique tables you can publish a subset of the db in each direction making for what...

william.rees.howells (3/19/2014)

In terms of what you were saying about slowing the reads down, would the most optimal scenario be to have both data drive and log file drive with equal...

william.rees.howells (3/19/2014)

---

Ok, so if we take my example again where I want to write 10MBs to a table every second, the drive that my log file resides on would have...

william.rees.howells (3/19/2014)

---

In the full recovery model, if i run a transaction that inserts 10MB of data into a table, then 10 MB of data is moved in the data file....

sqlbuddy123 (3/18/2014)

---

That's a good one recommended by Brain.

Also try to get some SQL Server DBA training. And here is a list of good books for SQL DBA.

http://www.brentozar.com/best-sql-server-dba-books/

Free books are available...

dbalmf (3/18/2014)

---

The data file does not shrink back if you delete a bunch of data which gives you the symptom you are seeing. If space is not an issue I...