What are the type of Indexes? which one is best, why?
Answer Posted / jay vardhan singh
Cluster is faster then non cluster index.We can use only
one cluster index on one table and we can use more then one
non cluster index on one table.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how many bits ip address consist of? : Sql server database administration
What is a natural primary key?
What is dynamic cursor in SQL SERVER?
What does truncate do?
What is the boxing and unboxing concept in .net?
Why use “in” clause in sql server?
What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?
What is the difference between varchar and nvarchar datatypes?
Explain the concept of recursive stored procedure.
how to create “alternate row colour”?
How to create hyperlink from returned sql query ?
What functions can a view be used to performed?
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
How do I run a trace in sql server?
What is database mirroring?