Implemented proactive database monitoring like locking, deadlock analysis,
long running query, clustering failover using DMVs and stored procedure which reduced database outage and improved performance
Analyzed
the longest running queries and determined how to make them more efficient.
Not exact matches
As you suggest, the point of a good
query is to get at the heart of what the book is about, so I'd think in the
long run, better, more focused
queries would help agents see more quickly whether this is the kind of story likely to interest them.
Don't let your
query letter
run longer than 1 single - spaced page.
When I saw the NPR report, I
queried Sydney Levitus, who's been tracking ocean heat buildup for a
long time and
runs the main effort keeping track of changes at NOAA.
Improved system response time by ~ 20 % by using SQL profiler to identify
long running SQL
queries and addressing them by either rewriting or adding indexes to the appropriate tables.