"Do the Work in SQL, Not the Client"

1. What is the main issue when reports handle grouping and aggregation on the client side instead of in SQL?

Increased server load Excessive network traffic Client performance issues Redundant database requests

2. Which SQL command is recommended to verify how many rows a report's dataset is returning?

SELECT COUNT(*) SELECT COUNT_BIG(*) SELECT SIZE() SELECT NUM_ROWS()

3. What is a suggested method to improve report performance according to the lesson?

Limit dataset retrieval to fewer rows Run queries asynchronously Perform all processing on the client Aggregate data using SQL functions

4. What does a high occurrence of ASYNC_NETWORK_IO in wait stats indicate?

The database is slow The client is not processing fast enough The server is overloaded The network is congested