drilldown

The term is sometimes used when referring to moving down through a hierarchy of folders and files in a file system like that of Windows. It may also mean clicking through a series of dropdown menus in a graphical user interface.

Microsoft's Visual Studio Analyzer is said to "provide easy drilldown," possibly meaning that it allows the user to get quickly to a desired function or work unit.

The term drillup is also reported in the multi-dimensional data access query language (MDX), which contains the keywords DRILLDOWNMEMBER and DRILLUPMEMBER as well as TOGGLEDRILLSTATE.

Learn more about Microsoft SQL Server Performance Monitoring and Tuning

	Using dynamic management views to monitor and tune performance of SQL Server: Dynamic management views help monitor SQL Server health and tune performance. Learn how to use DMVs to retrieve critical data on the internal workings of SQL Server.
Tutorial: Performance tuning SQL Server via queries, indexes and more: Get the basics for tuning SQL Server performance with this tutorial on queries, indexing, storage, memory and any errors or issues that can cause SQL Server slowdown.
Avoid cursors in SQL Server with these methods to loop over records: Avoid using a SQL Server cursor for looping over records row by row. Alternate methods use temp tables instead of SQL cursors that slow down performance.
Microsoft SQL Server 2008 Resource Governor primer: In this chapter excerpt from "Microsoft SQL Server 2008 Management and Administration", learn how Resource Governor can improve SQL Server performance.
Top 10 SQL Server Tips of 2008: Get the top 10 SQL Server tips of 2008 on topics such as clustered index design, log shipping setup, date/time data conversions and many other aspects of SQL Server.
Tutorial: Performance tuning SQL Server via queries, indexes and more: Get the basics for tuning SQL Server performance with this tutorial on queries, indexing, storage, memory and any errors or issues that can cause SQL Server slowdown.
Tutorial: SQL Server indexing tips to improve performance: Significantly improve your SQL Server performance through this tutorial on proper indexing choices. Learn how to design high performing indexes and tune your existing SQL indexes.
SQL Server Service Broker Tutorial and Reference Guide: Discover the major objects of the SQL Server Service Broker, including message types, contracts, queues, services and commands such as SEND and RECEIVE.

Do you have something to add to this definition? Let us know. Send your comments to techterms@whatis.com

More resources from around the web: - What Is a Drilldown Layer explains that a drilldown layer is a level of map detail. - It can also be used by a human factors company in describing its GUI development product . - A company in Houston and Dallas, Solution One, was the company that got the "drilldown.com" domain name . They sell Microsoft products.

FILE EXTENSION AND FILE FORMAT LIST File Extension and File Format List: A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #

RELATED CONTENT Using traces in SQL Server Profiler A SQL Server Profiler trace can provide critical information on a problem query in a matter of seconds. Learn how – and when – to run the... SQL Server Mailbag: CALs, witnesses and unwanted changes In this edition of the SQL Server Mailbag, database expert Denny Cherry answers reader questions on SQL Server licensing, monitoring IT personnel and... SQL Server Mailbag: Data restoration and DB property management In this edition of the SQL Server Mailbag, expert Denny Cherry tackles reader questions on recovering data after a disc crash, restoring databases...

RELATED GLOSSARY TERMS Terms from Whatis.com − the technology online dictionary contiguity  (SearchSQLServer.com) contiguous  (SearchSQLServer.com)