Autogrows will HALT all activity until disk space is allocated. 10% may not seem much when sizes are small it can be a big deal for large sizes or very...

I guess you should start at MSDN

Gaurav (1/12/2009)

---

Hi All

I have set up the merge replication in SSMS (management studio). I am able to perform merge replication between subscriber and publisher. But the synchronization process has to...

You you read about the "retention period" on the distributor.

It holds the key to your problem. You should increase the minimum time the transactions are "kept" in the distribution database...

I would never think that it is a good idea for the front-end to handle sending messages to peers for a number of reasons. Many of those being firewall uncertainties...

I think this is a FRONT-END task. The APP that successfully change a table should send a "message" to all clients that way you keep those CLR procedures to...

bpowers (1/14/2009)

---

I am trying to build a view that looks at our cust_address table data. However, there will be times when this information will be null. In that case I...

There are a lot of things that you can do to speed up the apps before thinking of keeping the entire database in memory.

It should be obvious from the above...

Log truncation is a "BAD" thing. Please, think TWICE before you do it!

The connection of the The App was killed !

You should start by verifying what was going on on the server at that time!

The database tools shipped with the workstation component should not be used to "ADMINISTER" a production Server. Scripts are the way to go because you will be in FULL Control...

bpowers (1/14/2009)

---

What am I doing wrong?

IF Cust_Address_v.ID IS NULL

THEN

SELECT ID, NAME, ADDR_1, ADDR_2, ADDR_3, CITY, STATE, ZIPCODE, COUNTRY,

FROM CUSTOMER

WHERE ID = 'S28171'

ELSE

SELECT ID, Addr_No, Name, Addr_1, Addr_2, City, State,...

Well I have never configured to have such long retention period but i...

Take Transaction log BACKUPS and the file size of those is what you should care about.

foxjazz (1/14/2009)

---

What are the differences between these two versions of replication?

Also, if I create a subscriber snapshot database, and script it to subscribe to a publisher, when I go offline,...