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 |
What is the difference between a view and a stored procedure?
what is the importence of the trigger in sqlserver2000?
What is global temp table?
What do you know about normalization and de- normalization?
Which index created when Create Index on table(col), Why
whats the maximum size of view state??
What does sql server mean?
How send email from database?.
3 Answers CarrizalSoft Technologies, Merrill Lynch,
How to display n-1 columns from n number of columns, from a single table in MS SQL server 2005?
What is de-normalization and what are some of the examples of it?
Do you know spatial data types - geometry and geography in sql server 2008?
how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?