The default search term operator is AND
You can use brackets, AND OR and NOT to improve your search. For example: C# AND NOT ( VB or SQL )
A query of a single * will return everything, filtered by any filters.
Search by Author: author:"author name"
Filter by tag: tag:C# or tag:(C++ or Java)
Wildcard search use: "?" or "*" eg. gr?d or gr*
Wait Statistics is first power full tool which a DBA uses to find performance bottleneck. But first question is that WHY WAITS OCCUR?
When comes to performance tuning for a poor performing SQL Server instance, biggest question is WHERE TO START looking at to resolve this performance issue. Why queries are waiting for ??? Wait Statistics is the first place which should be explored to directly hit the problem. But Why Waits Occur ? Lets find out.