Answer Posted / sanjay mukati
Index is a such type of mechanism in which records are
searched and fetched efficiently and fastly in a table. It
is physical address of data.
Two type of index :
A. Cluster Index
B. Noncluster Index
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
How to name query output columns in ms sql server?
What are the system database in sql server 2008?
Explain system scalar functions?
What is self contained scalar sub query?
Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?
How do we know if any query is retrieving a large amount of data or very little data?
What are partitioned views?
What is the synonym of join?
What is table join?
How do users use Report Builder with SQL Server data sources?
What is plan freezing?
In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram
there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
Which Model uses the SET concept
Explain primary key, foreign key and unique key?