For snapshot replication, the usual answer is to empty the tables before inserting new data into them. That's kind of the point of snapshot replication.

When I need to create...

Merge was introduced in SQL 2008. In prior versions of SQL Server, you have to build your own set of update, insert, delete statements. Used to be called...

It depends on the SATA generation, the SCSI version, how many I/O channels (drives, etc.) on each, the bus each is connected to on the motherboard, the buffer and I/O...

I'm not sure what you mean.

Are you trying to inventory all the servers on your network?

The reason I did the query with an inline sub-query instead of a defined UDF is because there's a performance cost to using a UDF just because it's an external...

I dug through my scripts library, and found this for age calculation:

-- Age Calculation (most accurate known version; does NOT take into account Leapling laws)

ISNULL(CAST((CAST(CONVERT(VARCHAR(25), GETDATE(),...

Use "Where Not Exists (select * from table where column is null)" as part of your where clause in your delete statement. That should give you what you need....

The question of hard vs soft deletes is a business decision, not a technical one.

How to implement either one is a technical question.

Is that what you're asking about?

I am definitely easy to work with, and anyone who disagrees will be shot! 😀

p-nut (11/22/2011)

---

GSquared (11/22/2011)

---

It won't catch an iteration from 09 to 10 in the last two digits. If you want that, you need to just modify the Left() and Right()...

The simple way to look for that kind of patterns in rows is to join a table to itself with the rules you want it to follow.

For example:

SELECT DISTINCT

...

Glad I was able to help at least that much.

The XQuery documentation sucks. I've had to learn far to much of it by just poking around and trying things...

Stefan Krzywicki (11/22/2011)

---

GSquared (11/22/2011)

---

Jack Corbett (11/22/2011)

---

I start a new job in less than 2 weeks and it is a telecommute. I need to buy a new monitor and chair...

I'm not clear on what you mean by selecting from files. Do you mean tables? Or are you trying to extract data from Excel or text files or...

Jack Corbett (11/22/2011)

---

I start a new job in less than 2 weeks and it is a telecommute. I need to buy a new monitor and chair for my office....