Thanks for all your valuable responses i agree with Lutz will fix the data.

Hi All,

Datatype for both the cols are int and allow null as it is a source for the ETL developement. UNQKEY will remail unique i.e. not null once the developement...

Its business key column not from the DTA

Hi All,

Its doing the clustered index scan.

Thanks to all for your kind response.

@jayanth KURUP : If the db is droped then it would be captured in the default trace ryt. Also as u said under same db exec select *...

@ricer & @arun_sql: There is no files for the Database but thing is that the person was using it and after 5 min of time login failed for...

OKay,

Thanks for the reply

@Gail : I agree your point but i am looking for way to handle the scenario in future, if i face the same situation mentioned in the post i.e. creating...

Thanks Suresh.:-)

I have one more thing to discuss, yesterday i created clusetered index on the same table and it took very long time to create the index. Is there any...

Hi Gail,

What is the use of sort in tempdb. I also cheched for the fragmented index using follwing script all the index i rebuid came to as fragmented why it...

Hi All,

Thanks for sharing your valuable knowledge and thoughts. After agreeing to bhuvnesh in post I have few observations as below.

I am using the syntax to rebuild the index as...

Thanks Adi,

I did the same thing:-)

Hey thanks Bhuvnesh,

I was planning to use tempdb but little confused whether rebuild will use tempdb or not. Now its clear.

Thanks alot:-)

Can u share how to point to different filegroup in alter index...rebuild syntax coz i dont find it.