(Ben Forta) In this lesson, you will learn how to use the SELECT statement’s ORDER BY clause to sort retrieved data as needed.

When you perform merge replication between a Microsoft SQL Server 2000 database and a Microsoft SQL Server 2000 Windows CE Edition version 2.0 (SQL Server CE) database that is running on a handheld device such as a Pocket PC, the merge replication agent may stop responding in the following situation

When you run the msmdarch command to archive or to restore a database in Microsoft SQL Server OLAP Services, the msmdarch command returns an exit code of 0 even if the archive or the restore operation fails. An exit code of 0 indicates that the archive or the restore operation completed successfully

(Brian Moran) SQL Server 2000’s ability to automatically update statistics for my tables and indexes is enabled by default. How often does SQL Server perform this update, and does the action have a negative effect on performance? (R,$)

(Andy Warren) I recently had to move several databases from one server to another and ran into a problem with transferring the SQL logins. If you take a look at SQL 7 Books Online for sp_addlogin, it explains how you can use it for transferring logins by setting the optional flag @encryptopt to

(Ashish Kaushal) How many times, we as a SQL developer or DBA, find ourselves shuffling through objects in Enterprise Manager, or expanding the left pane of Query Analyzer, trying to find a table or view for which we have no clue, except a nearly correct name, and the only way we would know that it

(Danny Lesandrini) Late last year I picked up a new client whose SQL Server data is accessed through an ADP file (Access Data Project). The Access part of the application was familiar enough and I am very comfortable with SQL Server, but the Data Project piece was new to me. The most frustrating a

When you run a Transact-SQL query, Microsoft SQL Server 2000 may underestimate the cardinality of the query expression. Therefore, the SQL Server query optimizer may not be able to generate an optimal query execution plan, and the query performance may be slow and inconsistent. This problem occurs w

The Sqlfstin.exe sample demonstrates how to perform quick, transactional inserts of a large number of records into SQL Server by using the IRowsetFastLoad interface and the ATL OLE DB consumer templates. The sample also shows how to roll back such transactions.

(Leo Peysakhovich) There are bunches of articles and books about database’s, application’s, and other types of performance. I would like to overview some interesting aspects related to the subject of performance or Transact SQL behavior in batch processes and in stored procedures. (R)