You mention that this is a .NET application? I would make sure at the application layer that it is doing everything possible to not insert data that it shouldn't. Are...

How or why do you think there is a problem? 6gb/8gb = 75%, not 97%.

Here is the proc:

USE test

GO

CREATE TABLE tab1 (id int,oldId int, InsertedOn datetime)

insert into tab1 values (99,NULL,getdate()-7)

insert into tab1 values (17,14,getdate()-9)

insert into tab1 values (14,12,getdate()-14)

insert into tab1 values (12,null,getdate()-15)

insert into tab1...

Let me see if I can explain this better for the OP. It is irrelevant the value of the ID in terms of max, min, >, <... He wants...

Going along with the previous response, if you cannot come up with a unique constraint (single or multiple columns) then it really doesn't matter if duplicates are moved or not...

First you need to add in your missing row that is in your results, but not in the sample data. Then use a recursive cte:

USE tempdb

GO

DECLARE @tab1 TABLE...

Andrew Watson-478275 (6/19/2012)

---

If it can be made to fit into your workflow, my inclination would be to create some kind of script to preprocess the file into this:

id , name...

Suresh B. (6/18/2012)

---

Why are you replicating in same server with different database?

Have you checked the Replication Monitor? Have you...

The best way would be to use DATEDIFF or DATEADD functions.

So, if you want to change 2012-03-30 13:57:07.353 to 2012-05-30 13:57:07.353 you would do this:

UPDATE tableA

SET dateColumn = SELECT DATEADD(MONTH,2,dateColumn)

WHERE...

When you stop SQL Agent, you are not just stopping the 1, 2, or 3 jobs that you have running for replication... You are stopping ALL jobs. This...

Jeff Moden (6/18/2012)

---

SQLKnowItAll (6/18/2012)

---

So, when working with a set of data I believe it is much easier and more flexible to use a presentation layer to arrange and display your...

Ok, I see now. Take a look at this thread and see if it helps. I personally have never had to do this.

Jeff Moden (6/16/2012)

---

Why? Not picking on you specifically. It's just that...

Again, I don't think I understand what you are trying to do. A job runs on a schedule, so how would it know what parameter is used unless it...

Although this can be done, it seems like what you want is actually a report that does the sum for you. You should not be doing this with an...