Microsoft SQL Server 2000

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)