May 2002
Beginner
408 pages
9h 10m
English
| 1: | For best performance, of the DataAdapter and DataReader objects, which would you use to bind database data to a pageable DataGrid object to display the results of a query on a form? |
| A1: | This is a trick question. Because you would be unable to page through data with a DataReader object, you should use the DataAdapter to return a DataSet. |
| 2: | Name one way you can improve the responsiveness of your queries using the Microsoft SQL Query Analyzer. |
| A2: | First, you can use the Query Analyzer to display SQL Server's execution plan for your query. You can use this plan to discover how you could better structure the query. Additionally, you can also use the Query Analyzer to analyze the indexes of your table. Often, the Query Analyzer ... |
Read now
Unlock full access