I read that in different white papers for setting up SQLserver 2008. I dont remember where though. Quite a few were saying to leave 10% for the OS and rest...

Isnt it a Rule of Thumb that you leave 10% of the total Memory to the OS and the rest for SQL Server?

Snapshot folder is not created by distribution agent if I am not mistaken. It is the Publisher that creates the Snapshot.

Just my 2 cents

Hey Lynn, Why not write about resource governor? There is a lot to write and it is a pretty interesting topic too.

When you are using Option 2, How many times are you forced to do a bulk update? 2 times? Replication is very chatty. So you are going to generate quite...

Grant,

I know I am not the best article writer.. 🙂 But I think I will give it a try if I ever am able to make some time. 🙂

I have...

Same server different instance means you are sharing the resources. Publisher, distributor and the subscriber.

1. CPU

2. RAM

3. IO

This will cause pretty bad performance. If your Disks are not configured...

I remember that we were watching CNN and they showed one building burning... And then I saw the next plane hit the other tower, I thought it was just a...

Nathan, Just keep in mind that using IF statement to figure out which Query to execute could cause parameter sniffing and might cause bad performance due to a bad plan....

Bob Hovious (9/11/2009)

---

First off I will apologize in advance, but I think all of you are correct.

Second, for a change, I would like to post a (rare?) example of an...

Hopefully the MVP will give more answers than asking questions... 😉

I say Silverfox is correct. :hehe:

Two more bottles og beer on the wall.. 🙂

Yes, that is correct on the first part. I am no expert in SSIS so I cannot give you an advice on that. If you want to do replication, then...

Jus, Umar and Me both gave you the right direction, please try to figure out from these two tables. Thats the only way to learn. If you find any problems...

Try DBCC PAGE