New & Notable
Microsoft SQL Server 2000 News
October 23, 2007
DBAs can build a SQL Server index best designed for their database environments by learning about columns, clustered indexes, and more.
Microsoft SQL Server 2000 Get Started
Bring yourself up to speed with our introductory content
A flat file is a collection of data stored in a two-dimensional database in which similar yet discrete strings of information are stored as records in a table. Continue Reading
Information is stimuli that has meaning in some context for its receiver. When information is entered into and stored in a computer, it is generally referred to as data. Continue Reading
A database management system (DBMS) is system software for creating and managing databases. A DBMS makes it possible for end users to create, protect, read, update and delete data in a database. Continue Reading
Manage Microsoft SQL Server 2000
Learn to apply best practices and optimize your operations.
A relational database management system (RDBMS) is a collection of programs and capabilities that enable IT teams and others to create, update, administer and otherwise interact with a relational database. Continue Reading
A DDBMS (distributed database management system) is a centralized application that manages a distributed database as if it were all stored on the same computer. 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.
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
SQL Server expert Adam Machanic's definition of a SQL Server instance. Continue Reading
What is data purging? What technology or method can I use to purge data in SQL Server 2000? Continue Reading