Amin Sobati | SQLServerCentral

Amin Sobati

Forum Replies Created

Viewing 5 posts - 1 through 5 (of 5 total)

RE: Data Corruption because of index on system table

No disk error!...

December 17, 2006 at 10:43 pm

#678570
RE: Data Corruption because of index on system table

That was an index on sysobjects table. Sp_fixindex repairs the error but when you create a new object, again dbcc checkdb reports error! You may easily simulate this on a...

December 17, 2006 at 2:00 pm

#678559
RE: The Pitfall of "Not Equal To" Operator in Queries!

Thanks Eva,
All of students appear again! You have replaced the NULL with new value, but the logic is the same!

August 24, 2006 at 12:53 pm

#656689
RE: The Pitfall of "Not Equal To" Operator in Queries!

Thank Duray!
I agree! But I intended to show a mistranslation between what a human can mean and what a developer might write in TSQL!...

August 24, 2006 at 4:02 am

#656517
RE: The Pitfall of "Not Equal To" Operator in Queries!

Thanks indeed!
Certainly there can be variations depending on the experience of the developer. I have tried to BOLD a situation that can lead a developer to...

August 24, 2006 at 2:30 am

#656510

Viewing 5 posts - 1 through 5 (of 5 total)