What is sorting and what is the difference between sorting
and clustered indexes?
Answer Posted / 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 |
Post New Answer View All Answers
Explain trigger and trigger types?
What happens if null values are involved in bitwise operations?
What are the steps you must follow to hide sql server instances?
Explain primary key in sql server?
What is “asynchronous” communication in sql server service broker?
How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?
Call by value and call by reference in procedure and function, with NOCOPY.
Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.
What do you mean by recursive stored procedure?
You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?
What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security
How to modify an existing user defined function?
What are the rendering extensions of ssrs?
What is the maximum length of an alert name?
How do I find sql server instance name?