Answer Posted / Ajit Singh
A table in SQL Server can have only one primary key and, consequently, one clustered index. If you attempt to create a second clustered index, the server will fail and return an error.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain “row_number()” in sql server with an example?
How raid can influence database performance?
How to convert character strings into numeric values?
What is a view in sql?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
List the ways in which dynamic sql can be executed?
What is a scheduled job or what is a scheduled task?
Is it possible to have clustered index on separate drive from original table location?
What is the difference between upgrade and migration in sql server?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
What is normalization and what are the advantages of it?
What is sql or structured query language?
Why we use the openxml clause?
List out the different types of locks available in sql server?
How do I find the sql server version?
