Answer Posted / srinivas
Index is a database object which improves the efficiency of
the query
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Which rendering formats are affected by the pagesize properties?
What are the five characteristics of good data?
Explain full-text query in sql server?
How to connect sql server management studio express to sql server 2005 express?
What is the difference between sdf and mdf?
Tell me can we use custom code in ssrs?
How to select some specific columns from a table in a query in ms sql server?
What is update_statistics command?
How does a profiler work?
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.
How will you add a dimension to cube? : sql server analysis services, ssas
What happens if null values are involved in boolean operations?
Suggest a method of joining two tables.
What action plan is preferred if sql server is not responding?
what is the difference between a primary key and a unique key? : Sql server database administration