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
what is the information that can be stored inside a bit column? : Sql server database administration
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
Your table has a large character field there are queries that use this field in their search clause what should you do?
What are the difference between data mart and data warehouse? : sql server analysis services, ssas
What is replication and database mirroring?
Write a sql query to sort on different column name according to the parameters passed in the function?
What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas
What is the simplest way to create a new database in ms sql server?
How connect excel to sql server?
What happens if we shrink log file in sql server?
Can we use having clause without group by?
What are policy management terms?
What is the difference between row_number and dense_rank?
How to receive output values from stored procedures?
How to convert binary strings into integers in ms sql server?