Hour 23

for RuBoard

Quiz Answers


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.

for RuBoard

Sams Teach Yourself ADO. NET in 24 Hours
Sams Teach Yourself ADO.NET in 24 Hours
ISBN: 0672323834
EAN: 2147483647
Year: 2002
Pages: 237

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net