This was indeed an excellent article. And I must second the fact that RBAR would catch on a lot faster if it was pronounced 'AR-BAR'.

Nita Reddy (3/12/2008)

---

My firm wants to install clustering Active/Pasive for one of there application.

That application does 200 Transaction per day, I mean 200 Update and insert will happen.

The database...

This was a beautiful article. Thank you for both testing and quantifying what is normally assumed.

Thanks Jeff. None of those are issues in my situations, but they make perfect sense for reasons someone might need to use this.

Haidong Ji, This is an excellent article and I appreciate the information.

I do have one question though, I have worked with a variety of technologies,...

Thanks Jeff. I was hoping for something that would identify a valid identifier that does not require brackets (or double quotes when quoted identifier is on), but like you...

I am trying to check if...

That certainly makes sense. If ensuring that there is always a matching row requires a great deal of work, then triggers are probably the way to go for you.

Matt is right that Triggers are the way to get exactly what you are describing, but have you considered restructuring the data so that the relationship always exists?

That...

sukhoi971 (2/27/2008)

---

iam having a problem,

iam managing a database with over 150,000 records

now iam getting erros becoz of null problem

i want to set the column default to 0

then column type is...

Sorry, I dropped off a parenthesis in there. Try:

declare @StoreKey int

select @StoreKey = 1

IF ((exists (select * from SYCFStore s WHERE s.Store_Key = @StoreKey AND s.Store_Inactive_Flag = 'N')...

MrBaseball34 (2/26/2008)

---

ok...the SQL above is used as a filter for building the menu for our software

and if the result of the query is 'Y', the menu is filtered out...

Daniel R. Kusnadi (2/21/2008)

---

Hi Thomas,

isn't just opening 'design table' from SQL management and edit the column to have identity or not, works as well?

or it might be just me...

Loner, if someone gets promoted, give them a chance at it. I once had someone who worked under one of my subordinates who was just barely competent at his...

Bill Wimsatt (2/19/2008)

---

This article is so "motherhood and apple pie" it says nothing. I do not think the work normalize or denormalize is even used. The author also did not...