Interested to Buy Any Domain ? << Click Here >> for more details...
WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN
SQL SERVER?
- 8 Answers
- 21792 Views
- I also Faced
- E-Mail Answers
Answer Posted / muthu
Clustered index based on Primary Key. So if we create a PK,
automatically Clustered Index will be created. So only one
CI available for a table.
| Is This Answer Correct ? | 10 Yes | 14 No |
Post New Answer View All Answers
How to convert numeric expression data types by assignment operations?
What are the different sql server versions?
Explain about sql server login?
How to create “dependant” parameter “make, model, year”
What are the different types of stored procedures?
how many bits ip address consist of? : Sql server database administration
Detail about the hardware which is supported by SQL server?
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?
What is shrink log file?
Explain the truncate command? : SQL Server Architecture
What are the advantages of using stored procedures in sql server?
How to rebuild the master database?
What is difference between table aliases and column aliases? Do they affect performance?
What is the difference between resultset and resultsetmetadata?
Explain the different types of backups available in sql server? : sql server database administration
