databasejournal.com databasejournal.com

Troubleshooting SQL Server Jobs

If you have problems with SQL Server jobs, review this troubleshooting checklist to find potential solutions. 1. Check that you use the latest SQL Server service pack. Because many bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. To check what SQL Server service pack are you running, see this link: How can I check what SQL service pack am I running? 2. Check that Task Scheduler...

databasejournal.com databasejournal.com

Troubleshooting SQL Server Alerts

If you have problems with Microsoft SQL Server alerts, review this troubleshooting checklist to find potential solutions. 1. Check that you are using the latest SQL Server service pack. Because many alert bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. Check "How can I check what SQL service pack am I running?" to find out which SQL Server service pack you are running. 2. Check...

databasejournal.com databasejournal.com

Managing Users Permissions on SQL Server - Page 2

Enhancing Security Using Views Views can be used to enhance security because permissions to access a view can be granted, denied, or revoked, regardless of the set of permissions to access the underlying table(s). Views can also be used to limit the data that is available to a user. For example, one peace of data can be accessible to users for modifications while another piece of data can be accessible to users for query, and the...

databasejournal.com databasejournal.com

Reducing SQL Server Index Fragmentation

General Concepts When you perform any data modification operations (INSERT, UPDATE, or DELETE statements) table fragmentation can occur. When changes are made to the data that affect the index, index fragmentation can occur and the information in the index can get scattered in the database. Fragmented data can cause SQL Server to perform unnecessary data reads, so a queries' performance against a heavy fragmented table can be very...

databasejournal.com databasejournal.com

Backing Up and Restoring SQL Server Databases and Transaction Logs

General Concepts The backing up and restoring of databases and transaction logs is a way that SQL Server provides to protect from data loss. The backup operation creates a copy of a database. This copy can be used to restore the database if media failure occurs or if the database is somehow damaged (for example, from user errors). SQL Server 2000 supports the following kinds of backup: Full database backup (it is a full copy of...

databasejournal.com databasejournal.com

Attaching and Detaching Databases on SQL Server

Introduction If you need to move a database, or database file to another server or disk, and you do not want to backup the database, copy the backup on another server, and then re-create the database from the backup, you can use the sp_detach_db and sp_attach_db system stored procedures to detach the database and then attach it again. Detaching and attaching databases can be used when you want to move the database files to a...

databasejournal.com databasejournal.com

A Comparison of SQL Server 2000 with Access 2000

Introduction Often people in newsgroups ask about some comparison of Microsoft SQL Server and Microsoft Access. In this article, I compare Microsoft SQL Server 2000 with Microsoft Access 2000 regarding hardware and software requirements, price, features and products limits. Platform comparison SQL Server 2000 only works on Windows-based platforms, including Windows 9x, Windows NT, Windows 2000 and Windows CE. Microsoft Access 2000...

databasejournal.com databasejournal.com

A Comparison of SQL Server 2000 With Sybase ASE 12.5 - Page 2

Software requirements SQL Server 2000 comes in six editions: Enterprise, Standard, Personal, Developer, Desktop Engine, and SQL Server CE (a compatible version for Windows CE) and requires the following software: Operating System Enterprise Edition Standard Edition Personal Edition Developer Edition Desktop Engine SQL Server CE Windows CE No No No No No Yes Windows...

databasejournal.com databasejournal.com

A Comparison of SQL Server 2000 With Sybase ASE 12.5 - Page 4

Features comparison Both SQL Server 2000 and Sybase ASE 12.5 support the ANSI SQL-92 entry level and do not support the ANSI SQL-92 intermediate level. In the Features comparison section of this article I want to make a brief comparison of the SQL Server T-SQL with Sybase T-SQL dialect and show some SQL Server 2000 and Sybase ASE 12.5 limits. Microsoft T-SQL vs Sybase T-SQL Microsoft SQL Server and Sybase ASE have a common heritage...

databasejournal.com databasejournal.com

A Comparison of SQL Server 2000 with DB2 v8.1

Introduction Often people in newsgroups ask about a comparison of DB2 and Microsoft SQL Server. In this article I will compare SQL Server 2000 with DB2 Universal Database version 8.1 regarding price, performance, platforms supported, SQL dialects, and products limits. Platform comparison SQL Server 2000 only works on Windows-based platforms, including Windows 9x, Windows NT, Windows 2000 and Windows CE. In comparison with SQL Server...

databasejournal.com databasejournal.com

A Comparison of SQL Server 2000 with DB2 v8.1 - Page 3

Price comparison One of the main Microsoft SQL Server 2000 advantage in comparison with DB2 Universal Database v8.1 is that SQL Server is cheaper. Another SQL Server advantage is that Microsoft includes the Online analytical processing (OLAP) and Data Mining as standard features in SQL Server 2000 Enterprise Edition. So, you can save up to four times with SQL Server 2000 Enterprise Edition if you use OLAP and Data Mining. The price...

databasejournal.com databasejournal.com

The comparison of SQL Server 2000 with Oracle 9i

Introduction Often people in newsgroups ask about some comparison of Oracle and Microsoft SQL Server. In this article, I compare SQL Server 2000 with Oracle 9i Database regarding price, performance, platforms supported, SQL dialects and products limits. Platform comparison SQL Server 2000 only works on Windows-based platforms, including Windows 9x, Windows NT, Windows 2000 and Windows CE. In comparison with SQL Server 2000, Oracle...

databasejournal.com databasejournal.com

Troubleshooting SQL Server 2000 installation issues

Should you have problems installing SQL Server 2000, review this troubleshooting checklist to find potential solutions. 1. Check the hardware requirements. You should have: Intel or compatible platform Pentium 166 MHz or higher (Pentium II, III, IV and compatible) 32MB RAM (minimum for Desktop Engine),   64MB RAM (minimum for all other editions)   128 MB RAM or more recommended 270MB (full installation),...