I wouldn't think so. If, for instance, you partition on date, you won't want the date to be in the primary key. The partition value is not used...

Tom.Thomson (9/27/2010)

---

And transactional replication certainly doesn't create any extra columns by magic (at least in didn't in SQLS 2000), and neither does snapshot replication; merge replication may do it (I've...

Agreed Robert, but I have seen cases where people assumed that the IDENTITY was guarding the data for uniqueness and so inserted dupes by mistake, assuming that it would be...

Well, you CAN use SET IDENTITY_INSERT ON to create duplicates. Unless you have a unique constraint nothing prevents this from happening.

On the replication and uniqueidentifer topic:

PK is required for transactional and merge. It must be declared as such or else you can't even create a publication with that table...

Robert Frasca (9/24/2010)

---

jeff.mason (9/24/2010)

---

sjimmo (9/24/2010)

---

I use replication heavily in our stores, to move high priority data back and forth with HQ....

sjimmo (9/24/2010)

---

I use replication heavily in our stores, to move high priority data back and forth with HQ. I personally have...

As far as NULLs go, I have to say NULL is a good thing for some DATE columns. If you have, say, a StartDate and an EndDate column, you...

While we are at it, how about a DMV that allows you to get not only file size for DB files, but also total space and free space on the...

Get rid of the garbage 2008 Activity Monitor and go back to the 2005 Activity Monitor, and if you want the nice graphs or whatever either make it another tab...

And to be explicit, that last post was also intended as a thank-you to Wayne....

The CTE fixed it in live, but now we know that it just did it because of the order. I had reproduced the problem on stage and was trying...

Yeah, I know, I feel stupid too. What can I say, it was 11:30 PM, we are tired, and stuck in a rut for troubleshooting. We attacked the...

He's in training today so I have to wait. Actually I will be happy to get him to buy lunch or something....

I think I am going to kill that developer tomorrow....

(I say this knowing that he reads this forum and probably will see this before we talk 😛 )

All I...