Answer Posted / hari
cluster Index create leaf level of (actul data) data.
Non-cluster Index create pointer level of data.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
Difference between report and query parameter. Why do we need different type of parameter?
What is the definition for sql server 2000?
Explain some stored procedure creating best practices or guidelines?
What is a periodical index?
What is scan table/view and seek table/view when its occurs? : sql server database administration
What is the use of @@spid?
How to remove duplicate rows from table except one?
What is the maximum size of column in sql server?
What are data files?
What are the differences between having and where clause.
Can primary key be a foreign key?
What is read uncmmited?
What is a primary index?
What is deploy, process and build? : sql server analysis services, ssas
