Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN
SQL SERVER?

Question Posted / raju.r

Answer Posted / raju.r

we can create ony ONE clustered index per table .. for Non-
clusrtered index we can create 249 ...

Is This Answer Correct ?    4 Yes 11 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to set database to be single_user in ms sql server?

967

What is a natural primary key?

951

How do I find the query plan in sql server?

907

How do I trace a query in sql server?

900

you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration

1193

How to count duplicated values in a column in ms sql server?

997

What are the advantages of stored procedure in sql server?

833

Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication

980

If we delete pack Spec what will be the status of pack Body ?

1431

explain extended properties

927

Why I have to use stored procedures?

979

Explain the rules for designing files and file groups in sql server?

932

What is the command dbcc checkdb used for?

963

What is lookup override?

959

What is an indexing strategy?

943