SQL Server 7.0 is a fully featured relational database management system (RDBMS) for Windows NT-based systems. It helps design tailored solutions for business operations, electronic commerce and mobile computing. Version 7.0 scales to fit the needs of your organization. It offers data warehousing for faster and smarter decision-making, and integration with Microsoft Office 2000, Microsoft BackOffice, and Microsoft Windows. SQL Server 7.0 scales from laptop databases and small business servers all the way up to terabyte-size databases. It integrates well with existing applications, and it provides a cost-effective environment for customizing and building new applications that meet unique requirements. Many standard database administration operations are automated in version 7.0. The Dynamic Self-Management tool automates many routine tasks, including automatically growing and shrinking file sizes and dynamically adjusting memory and lock resources. Profiling and tuning tools simplify the process of finding and fixing database problems by enabling you to capture and relay server activity.With SQL Server 7.0, you no longer need expensive add-ons to handle full-text database searches. SQL Server 7.0 supports linguistic search, allowing you to create special indexes of pertinent words and phrases in selected columns of selected tables. And a new wizard and formating option that enhances the SQL Server Web Assistant allows you to easily create HTML files from SQL Server data. SQL Server 7.0 offers a comprehensive approach to data warehousing. Using the online analytical processing (OLAP) services, you can develop a variety of enterprise solutions, such as corporate reporting and analysis as well as data modeling and decision support. Data Transformation Services (DTS) makes it easy to import, export and transform heterogeneous data using OLE DB, Open Database Connectivity (ODBC), or text-only files.

General

Details

	Category Programming tool Subcategory Programming - database / connectivity Version 7.0 Language(s) English