Email Alerts
-
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. FAQ
-
Chapter Download: Essential SQL Server 2000 maintenance
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 Chapter Download
-
Learning Guide: SQL Server basics
SQL Server is gaining ground in the database space. As more companies turn to the DBMS hyped as the low-cost big player, more DBAs will have to learn its intricacies. With that in mind, we created this learning guide, highlighting basic SQL Server in... Learning Guide
-
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. Tip | 23 Oct 2007
-
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. Article | 06 May 2005
-
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. Tip
-
Error 21002 cloning SQL Server 7 database solution
This tip allows the cloning of SQL Server 7 databases to SQL Server 2000 that have named users with database administrator privileges. Tip
-
SQL Server 2000 Service Pack 4: An overview
Serdar Yegulalp discusses the most important new features in SQL Server 2000 Service Pack 4. Tip
-
Finding the SQL Server default collation
Learn how to get the description of the SQL Server 2000 default collation as given in setup. Tip
-
Get a random sample of rows in SQL Server 2000
Here's how to randomly sample a query's rows with Microsoft SQL Server. Tip
-
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. Ask the Expert
-
Problems running SQL Server 2000 RTM without service pack
Business Intelligence expert Eric Brown helps troubleshoot database growth problems. Ask the Expert
-
What is a SQL Server instance?
SQL Server expert Adam Machanic's definition of a SQL Server instance. Ask the Expert
-
Strange error when installing SQL Server 2000 Developer Edition
Greg Low helps identify what may be causing a "pending file operations" error. Ask the Expert
-
Is there an upgrade cost to SQL Server 2005 when you have SQL Server 2000?
Ask the Expert
-
Setting up automatic switchover between SQL Server instances
In the event that your primary SQL Server 2000 Standard Edition box has a meltdown, is it possible to kill replication on an identical, secondary box to make that the new primary? Contributors Adam Machanic and Hilary Cotter offer their advice. Ask the Expert
-
Can I connect SQL Server 2000 with SQL Server 2005 instances?
Ask the Expert
-
How to get started learning about SQL Server
I have been working in the IT field for 25 years now and have installed SQL Server onto systems/servers, but have not been able to actually work with the product. I have some opportunity to work with some clients and have told them that I need to get... Ask the Expert
-
All about data purging
What is data purging? What technology or method can I use to purge data in SQL Server 2000? Ask the Expert
-
Pros and cons of data warehousing with SQL Server 2000
Ask the Expert
- See more Expert Advice on Microsoft SQL Server 2000
-
Quiz: Database Basics
Directions: - After reading the question, click on the answer that you think is correct. Quiz
-
flat file
A flat file is a file containing records that have no structured interrelationship. Definition
-
OLE DB (OLEDB or Object Linking and Embedding Database)
OLE DB is Microsoft's strategic low-level application program interface (API) for access to different data sources. Definition
-
comma-separated values file (CSV)
In computers, a CSV (comma-separated values) file contains the values in a table as a series of ASCII text lines organized so that each column value is separated by a comma from the next column's value and each row starts a new line. Definition
-
Fast Guide: SQL Server 2000 commands
Here are ten commands you need to know! Definition
-
relational database
A relational database is a collection of data items organized as a set of formally-described tables from which data can be accessed or reassembled in many different ways without having to reorganize the database tables. Definition
-
SQL Server
SQL Server is a relational database management system (RDBMS) from Microsoft that's designed for the enterprise environment... Definition
-
relational database management system (RDBMS)
A relational database management system (RDBMS) is a program that lets you create, update, and administer a relational database. Definition
-
full-text database
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 to text documents, images ... Definition
-
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. Definition
- See more Definitions on Microsoft SQL Server 2000
-
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. Tip
-
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. Ask the Expert
-
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. Tip
-
Quiz: Database Basics
Directions: - After reading the question, click on the answer that you think is correct. Quiz
-
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. FAQ
-
flat file
A flat file is a file containing records that have no structured interrelationship. Definition
-
OLE DB (OLEDB or Object Linking and Embedding Database)
OLE DB is Microsoft's strategic low-level application program interface (API) for access to different data sources. Definition
-
comma-separated values file (CSV)
In computers, a CSV (comma-separated values) file contains the values in a table as a series of ASCII text lines organized so that each column value is separated by a comma from the next column's value and each row starts a new line. Definition
-
Fast Guide: SQL Server 2000 commands
Here are ten commands you need to know! Definition
-
relational database
A relational database is a collection of data items organized as a set of formally-described tables from which data can be accessed or reassembled in many different ways without having to reorganize the database tables. Definition
- See more All on Microsoft SQL Server 2000
About 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.