Microsoft SQL Server 2000
Home > SQL Server Topics > Microsoft SQL Server Platforms > Microsoft SQL Server 2000
SQL Server Topics:
EMAIL THIS
 TOPICS HOME   BROWSE ALL SQL SERVER TOPICS     RSS FEEDS 

Microsoft SQL Server 2000


SQL Server 2000 is Microsoft's original database management system, replacing SQL Server 7.0 with the release of the Windows 2000 opertaing system. For those who have yet to upgrade to SQL Server 2005 or 2008, this page features resources focused specifically on Microsoft SQL Server 2000. Here you'll find tips, articles and even basic tutorials for database administrators and developers, as well as information on planning a migration away from SQL Server 2000 to a more recent DBMS.
IN THIS TOPIC:  EXPERT TECHNICAL ADVICE (13) , REFERENCE & LEARNING (4) , NEWS (1) , WHITE PAPERS , DEFINITIONS (14)

MUST READ
Tutorial: Learn SQL Server basics from A-Z
TUTORIAL - If you're new to SQL Server of simply want a refresher on some fundamentals, check out this tutorial on topics from security and performance to SSIS and using native tools.
Top 10 SQL Server Tips of 2007
THE YEAR IN REVIEW - Get the top 10 SQL Server tips of 2007 on topics of SQL Server database design and performance tuning to upgrading to SQL Server 2005 and stored procedures.
Tutorial: SQL Server Integration Services (SSIS) best practices
TUTORIAL - Learn the best practices for SQL Server Integration Services (SSIS) in this tutorial, from migrating DTS packages to SSIS debugging, maintenance and programming in SQL Server.
Top 10 T-SQL tips for improved SQL Server development
TOP EXPERT TIPS - Find out how to script SQL Server backups, why T-SQL in SSIS has pros and cons and what to do about poorly written T-SQL code that's causing SQL Server performance problems.
Tutorial: SQL Server indexing tips to improve performance
TUTORIAL - 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.

  EXPERT TECHNICAL ADVICE: 1 - 3 of 13
Track changes to SQL Server 2000 and 2005 with one simple utility
Submitted By: SearchSQLServer.com | 02 Apr 2008
TIP - SQL Server triggers have limits when tracking changes. Use scripts in this utility to monitor SQL Server 2000 and 2005 for new objects, logins and databases.
Is it possible to find disabled indexes in SQL Server 2000?
06 Dec 2007
EXPERT ANSWER - If you're working with SQL Server 2000 and trying to find a disabled index, here's something you should know.
What is a SQL Server instance?
27 Feb 2006
EXPERT ANSWER - SQL Server expert Adam Machanic's definition of a SQL Server instance.
VIEW ALL EXPERT TECHNICAL ADVICE ON MICROSOFT SQL SERVER 2000

  REFERENCE & LEARNING: 1 - 3 of 4
FAQ: Creating and altering SQL Server tables
SearchSQLServer.com | 19 Jun 2007
FAQ - Selecting rows, moving records and tracking table activity are a few of the tasks discussed in this SQL Server tables FAQ.
FAQ: SQL Server comparison features
SearchSQLServer.com | 14 May 2007
FAQ - In this FAQ, our SQL Server experts answer your questions about comparison features in both SQL Server 2000 and SQL Server 2005.
Chapter Download: Essential SQL Server 2000 maintenance
Addison-Wesley Professional | 12 May 2005
CHAPTER DOWNLOAD - This chapter from the book, Essential SQL Server 2000, by Buck Woody discusses two types of maintenance tasks: tasks that keep the database going and tasks that keep the database going fast
VIEW ALL REFERENCE & LEARNING ON MICROSOFT SQL SERVER 2000

  NEWS: 1 - 1 of 1
SQL Server DBMS' growing popularity is no coincidence
SearchSQLServer.com | 05.26.2006
OPINION - SQL Server offers more robust features at a lower price point than competing database management systems, making its growing popularity no surprise to contributor Adam Machanic. In this column, he details the advantages of ...
VIEW ALL NEWS ON MICROSOFT SQL SERVER 2000

  WHITE PAPERS
Databases and ERP Selection: Oracle vs SQL Server
Published by: IFS | 19 Jun 2009
WHITE PAPER - How do Oracle and Microsoft SQL Server database platforms compare on reliability, scalability and cost when run under enterprise software? Download this white paper for details.
Leveraging Virtualization for Application Assurance
Published by: AppAssure Software | 09 Jun 2009
WHITE PAPER - Business continuity. Application assurance. Virtualization. Consider that a mission-critical progression. Virtualization answers the need for business continuity and challenge of application assurance enabling companies to quickly and seamlessly recover from e-mail outages and keep business on track.
SQL Server Database Backup and Restore Planning
Published by: AppAssure Software | 09 Jun 2009
WHITE PAPER - Whether a business is small, medium or large business, it must have a well-written plan for backing up the servers. Planning a backup strategy up-front and documenting not only the backup process but also the restore process, will save you a ton of time in the end. Read this paper for backup tips.
VIEW ALL WHITE PAPERS IN THIS TOPIC
  DEFINITIONS: 1 - 3 of 14
SQL Server
10 Jan 2006
WORD - SQL Server is a relational database management system (RDBMS) from Microsoft that's designed for the enterprise environment. SQL Server runs on T-SQL (Transact -SQL), a set of programming extensions from Sybase and Microsoft ...
full-text database
13 Sep 2005
WORD - A full-text database is a compilation of documents or other information in the form of a database in which the complete text of each referenced document is available for online viewing, printing, or downloading. In addition ...
intelligent database
13 Sep 2005
WORD - An intelligent database is a full-text database that employs artficial intelligence (AI), interacting with users to ensure that returned items (hits) contain the most relevant information possible. This is in contrast to a ...
VIEW ALL DEFINITIONS ON MICROSOFT SQL SERVER 2000

SEE ALSO - Topics Related to Microsoft SQL Server 2000: 
Microsoft SQL Server 2005 (Yukon), Microsoft SQL Server 2008 (Katmai)



Microsoft SQL Server 2000 Solutions - SQL Server Topics

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