WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN
SQL SERVER?
Answer Posted / abhijit
A clustered index sorts and stores the data rows in the
table based on the index key values. Therefore only one
clustered index can be created on each table because the
data rows themselves can only be sorted in one order.
Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
Give an example of SQL injection attack ?
I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration
If you want to send some data from access database to sql server database. What are different component of ssis will you use?
Can we write trigger for view?
What are the difficulties faced in cube development? : sql server analysis services, ssas
What are the five major components of a dbms?
What is row_number()?
What is nolock?
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
Why main is user defined function?
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
Can we call stored procedure in view in sql server?
What is a fan-out query in SQL Azure?
Can we join two tables without primary key?