concept area in category sql

appears as: reas, area, areas, The areas, n area
SQL Server MVP Deep Dives Vol. 2

This is an excerpt from Manning's book SQL Server MVP Deep Dives Vol. 2.

After boot camp is over and a Marine enters what’s called the FMF (Fleet Marine Force), decisions are made to help further each Marine’s career. Each Marine needs to determine what area of his or her career he or she needs to dedicate more time to so he or she can improve as an individual. In the same fashion, commanders review the troops to determine what the group needs to improve on to enhance it as a whole. Although some choose to focus on physical fitness and others choose areas such as education, all of them choose to continue to learn from past experiences to improve the future.

SQL Server DMVs in Action: Better Queries with Dynamic Management Views

This is an excerpt from Manning's book SQL Server DMVs in Action: Better Queries with Dynamic Management Views.

Knowing the areas of the query that are slow allows you to try other techniques (for example, adding a new index) to see its effect on subsequent performance. Applying these new features leads us into the area of performance tuning. We’ll investigate a great many ways of identifying problems in the rest of the book.

Sometimes you’re interested in only the extreme examples of problems, because this allows you to target your efforts on areas that you know will have the most significant impact. For example, if you’re interested in the longest-running queries, you could get a list of 100 or more of them. But it’s probably true that the most expensive 10 or 20 will account for most of the slow performance seen on the server.