it will allocate more space on disk.

What is the disadvantages of index?

Question Posted / naren

Answer Posted / naren

Is This Answer Correct ?

15 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How to generate random numbers with the rand() function in ms sql server?

1150

how will add additional conditions in sql?

1098

What are the different types of subquery?

1154

What are the recovery models in sql server 2000?

961

Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

1391

What are user-defined functions (udfs) in sql server?

989

What are the new security features added in sql server 2012? : sql server security

1023

What guidelines should be followed to help minimize deadlocks?

943

What is subquery in sql?

1067

Please explain what is “asynchronous” communication in sql server service broker?

934

What is dbcc?

1135

How to assign new column names in a view?

918

Explain Reporting Life Cycle?

129

How to optimize stored procedure optimization?

892

What is filtered index?

1095