what type of indexes physically sort data?
Answers were Sorted based on User's Feedback
Answer / vikas kant
Clustered Index---It Reorders the way in which the data is
physically stored.
Is This Answer Correct ? | 6 Yes | 0 No |
What is checkpoint process in the sql server?
Difference between LEN() and DATALENGTH() in sql server ?
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
How to write a query with an inner join in ms sql server?
what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?
Which is the latest version of sql server and when it is released?
How can I create a new template for import ? : sql server management studio
What is the Difference Between Primary and Foreign Key?
0 Answers Accenture, Deloitte, JPMorgan Chase, Maveric,
I have a table EMP in which the values will be like this EmpId Ename Sal DeptId 11 Ram 10000 10 11 Ram 10000 10 22 Raj 20000 20 22 Raj 20000 20 33 Anil 15000 30 33 Anil 15000 30 I want to delete only duplicate Rows. After Delete I want the output like this EmpId Ename Sal DeptId 11 Ram 10000 10 22 Raj 20000 20 33 Anil 15000 30
How to list all schemas in a database?
Can we write ddl in trigger?
What is one of the first things you would do to increase performance of a query? For example, a boss tells you that ?a query that ran yesterday took 30 seconds, but today it takes 6 minutes?
2 Answers Accenture, Merrill Lynch, Wipro,