contiguous
Home > SQL Server Definitions - Contiguous
SearchSQLServer.com Definitions (Powered by WhatIs.com)
EMAIL THIS
LOOK UP TECH TERMS Powered by: WhatIs.com
Search listings for thousands of IT terms:
Browse tech terms alphabetically:
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 #

contiguous


Show me everything on Microsoft SQL Server Performance Monitoring and Tuning

DEFINITION - Contiguous describes two or more objects that are adjacent to each other. In computing, contiguous data is data that is moved or stored in a solid uninterrupted block.

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.

LAST UPDATED: 01 Apr 2005

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)




contiguous Solutions - SQL White Paper Library
HomeNewsTopicsITKnowledge ExchangeTipsAsk the ExpertsMultimediaWhite PapersIT Downloads
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 2005 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts