contiguous

In general, contiguous data can be accessed more quickly than data that is stored in fragments because fewer access operations will be required. Files are sometimes stored in fragments so that storage space can be used more efficiently (all the small spaces can be used).

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

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) drilldown  (SearchSQLServer.com)