What is sorting and what is the difference between sorting
and clustered indexes?
Answer / saravakumar
The ORDER BY clause sorts query results by one or more
columns up to 8,060 bytes. This will happen by the time when
we retrieve data from database. Clustered indexes physically
sorting data, while inserting/updating the table.
Is This Answer Correct ? | 5 Yes | 1 No |
If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security
Tell me the use of keyword with encryption. Create a store procedure with encryption?
How to perform key word search in tables?
what is new philosophy for database devises for sql server 7.0? : Sql server database administration
select names starts with a,b,c
8 Answers Scope International,
What are the different types of stored procedures?
Can you explain some of the DTS problems?
You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?
Why use update_statistics command in sql server?
What is the difference between dropping a database and taking a database offline?
How to select some specific rows from a table in ms sql server?
How does index makes search faster?