Vinod Pal (9/24/2013)

---

Read this article, I have the same dilemma (my boss calls it an opportunity) and will be looking to partition the 'log' tables by date, once partitioned then...

Purging data in batches can be considered but considering that the website is a 24*7 environment, there will be locking issues at times plus high CPU and log writes....

I fourth that but please explain what it means:-) Hidden meaning is not clear to me...

Thanks

Chandan

Jason-299789 (6/11/2013)

---

Be careful with CTE's they arnt always the best way to go, but try them to see what happens.

You might also get an improved performance by switching the CTE's...

Jason-299789 (6/10/2013)

---

THe problem you may have is with all the Nested Derived tables.

How many records are being populated into the TEMP table as i m not sure you need...

Thanks a lot for your help on this. Will post again if I find difficulty in this method. worth giving a shot rather than snapshot method.:-D

Cheers!

Chandan Jha

Thanks Bhaskar. Will try this option once to see how it works. I have a question though. Lets say that the replication is running for 1 subscriber and I edit...

Bhaskar.Shetty (5/23/2013)

---

Another option other then suggested above would be, Initilizing the subscriber from backup, this saves a lot of time of applying snapshot to subscriber,

The intial snapshot apply would...

Thank you folks for replying. I have kept the publisher common and added the B and C as subscribers there only. Initially, I was not able to reinitialize server C...

opc.three (5/16/2013)

---

chandan_jha18 (5/16/2013)

---

As you posted, you have already fixed SQL Server and given it a range between which it an fly up or down.

I would suggest to collect some 'Available...

As you posted, you have already fixed SQL Server and given it a range between which it an fly up or down.

I would suggest to collect some 'Available Memory' through...

When you talk of an issue with some server, I will say that when it comes up replication will assume automatically from where it left off.

Lets say that the publisher...

Before writing anything, I want you to inform that 'cancel' a rebuild task is not something nice to do and could land you up in a bad scenario.

Please try to...

sestell1 (4/3/2013)

---

If you don't want to add in all of the accounts, you could create a group (either in the domain, or locally on the SQL Server box), then add...

ChrisM@Work (3/22/2013)

---

It's difficult to tell with all of those funky joins and no sample data, but you might get a win with this too;

SELECT CAST(ID AS NUMERIC(9))

INTO #Accounts

FROM dbo.SplitIDs(@vcAccountId, ',')

SELECT...