Is this ever going to end ?

That's funny!

Jerry Sommerville (3/5/2009)

---

We have a client server application that supports ~2000 users. The DB is close to 200GB in size and is located on a EMC Clarion SAN with...

Can you just create a Unique Constraint ?

Does this helps:

declare @t table(acc int, CustName varchar(100))

insert into @t (acc, CustName) VALUES (1234, 'Joe Smith')

insert into @t (acc, CustName) VALUES (1234, 'Mary Smith')

insert into @t...

Bob, How does it compares with Steve's Solution ?

Mohit (3/5/2009)

---

Heh Thanks Noel.

After I finish my Part 2 for Denormalization Article ..

I think I know what I am going to Rant about next maybe I'll just rant on...

Mohit (3/5/2009)

---

Luckily I haven't ran into replication much. Because as the only technology seems to be the defacto where I work is clustering or nothing heh. But for...

OOps sorry!

RCSI = Read Committed Snapshot Isolation

You set it with:

ALTER DATABASE [dbname] SET READ_COMMITTED_SNAPSHOT ON;

Note: You will need...

florian.reischl (3/5/2009)

---

Wow, that's some news there! How can you not like identity columns? I tell database developpers to put 1 on each and every table in the database. Only in...

Jean-François Bergeron (3/5/2009)

---

Wow, that's some news there! How can you not like identity columns? I tell database developpers to put 1...

http://users.drew.edu/skass/sql/NameMoney.sql.txt

SQL Dude (3/5/2009)

---

Perfect, they are. That makes things more clear now. I was tracking down why replication was causing some blocking on index objects that were not related...

Note that there is also one exception that is related with the "SubscriptionStreams".

Which introduces more uncertainty on the predictability of the order of the transactions... I believe this was...

Then the combination makes a good clustered index !