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?
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 .
Name one way you can improve the responsiveness of your queries using the Microsoft SQL Query Analyzer.
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 will suggest index improvements that can greatly improve the speed of your queries.