Answer Posted / raj
The index is Nothing but quickly show the data on screen.
it's used for fast retrivel of data from tables.
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
What is built-in/administrator?
What is report subscription?
what is the difference between Delete and Truncate command in SQL
Should you normalize audio?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
what purpose does the model database serve? : Sql server database administration
List out some of the requirements to set up a sql server failover cluster?
Explain how would you store your query in an SSRS report or a Database server?
How do I port a number to sql server?
what are acid properties? : Sql server database administration
How to how to convert numeric expression data types using the convert() function??
What is the optimization being performed in oracle and SQL Server?
how you can configure a running aggregate in SSRS?
Why de-normalization required?
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
