Microsoft SQL Server 2000
New & Notable
Microsoft SQL Server 2000 News
-
October 23, 2007
23
Oct'07
Q&A;: Create and tune indexes in SQL Server 2000
DBAs can build a SQL Server index best designed for their database environments by learning about columns, clustered indexes, and more.
-
May 06, 2005
06
May'05
Microsoft offers update for SQL Server 2000
Service Pack 4 rolls up previous fixes for the database management software and adds some new features as well.
Microsoft SQL Server 2000 Get Started
Bring yourself up to speed with our introductory content
-
Quiz: Database Basics
Directions: - After reading the question, click on the answer that you think is correct. Continue Reading
-
FAQ: Creating and altering SQL Server tables
Whether you want to select rows, move records, track activity or perform various other table-related tasks, this collection of frequently asked questions offers expert insights to help. Continue Reading
-
flat file
A flat file is a file containing records that have no structured interrelationship. Continue Reading
Evaluate Microsoft SQL Server 2000 Vendors & Products
Weigh the pros and cons of technologies, products and projects you are considering.
View All EvaluateManage Microsoft SQL Server 2000
Learn to apply best practices and optimize your operations.
-
Is there an upgrade cost to SQL Server 2005 when you have SQL Server 2000?
Adam Machanic 3 weighs in on upgrade costs. Continue Reading
-
relational database management system (RDBMS)
A relational database management system (RDBMS) is a program that lets you create, update, and administer a relational database. Continue Reading
-
database management system (DBMS)
A database management system (DBMS), sometimes just called a database manager, is a program that lets one or more computer users create and access data in a database. Continue Reading
Problem Solve Microsoft SQL Server 2000 Issues
We’ve gathered up expert advice and tips from professionals like you so that the answers you need are always available.
-
Track changes to SQL Server 2000 and 2005 with one simple utility
As a DBA, you need to be aware of what's happening within your SQL Servers. But if you have dozens of SQL Servers -- both 2000 and 2005 models -- and permissions are shared, you'll have to go beyond the limits of triggers. Continue Reading
-
Is it possible to find disabled indexes in SQL Server 2000?
If you're working with SQL Server 2000 and trying to find a disabled index, here's something you should know. Continue Reading
-
Problems running SQL Server 2000 RTM without service pack
Business Intelligence expert Eric Brown helps troubleshoot database growth problems. Continue Reading