Answer Posted / krishna chaithanya
index allows to search record in a table making the search
meachnism faster and effective
| Is This Answer Correct ? | 14 Yes | 1 No |
Post New Answer View All Answers
Explain nested join?
whats the maximum size of view state??
What are the new features of sql server 2012 reporting service?
Explain trigger and its types?
How to use "if ... Else if ... Else ..." Statement structures in ms sql server?
Why use view instead of a table?
Can we join two tables without primary key?
Explain log shipping and mention its advantages.
What is dml command?
What is the downside of using udf?
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
Difference between report and query parameter.
What are xml indexes?
What are types of storage modes? : sql server analysis services, ssas