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.
May 06, 2005
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
If the database is a file of information, then the DBMS is the file folders, the file labels and the file cabinet. Continue Reading
After reading the question, click on the answer that you think is correct. Continue Reading
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
Evaluate Microsoft SQL Server 2000 Vendors & Products
Weigh the pros and cons of technologies, products and projects you are considering.
Product ReviewsPowered by IT Central Station
Running long and complicated queries could make the software crash, but it allowed to me make all kinds of important reports easily.Powered by IT Central Station
Valuable Features: The ability to browse table structures and re-design it easily. • Improvements to My Organization: It improved the...Continue Reading
For a free product, it has a relatively fast load. However, the Enterprise Edition is too expensive for something that won't replace our Oracle DWH database.Powered by IT Central Station
Valuable Features: The high compression and the relatively fast load for a free product. • Use of Solution: I used the Community...Continue Reading
We're able to create an end-to-end automated BI platform, but we'd prefer hosting multidimensional OLAP instances with Tabular rather than the either/or installation.Powered by IT Central Station
Valuable Features: Business intelligence platform Analysis services (multidimensional and tabular) Relational database features Data...Continue Reading
Manage Microsoft SQL Server 2000
Learn to apply best practices and optimize your operations.
Adam Machanic 3 weighs in on upgrade costs. Continue Reading
A relational database management system (RDBMS) is a program that lets you create, update, and administer 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
If you're working with SQL Server 2000 and trying to find a disabled index, here's something you should know. Continue Reading
Business Intelligence expert Eric Brown helps troubleshoot database growth problems. Continue Reading