When you perform large in-memory sort operations in Microsoft SQL Server 2000, SQL Server may not yield to the SQL Server User Mode Scheduler (UMS). This behavior could lead to stalled worker requests. When this problem occurs, connection timeouts and other time-sensitive operations may fail. When t

(Don Peterson) In Part 1 of this series I talked about transactions in general, I explored the three Transaction Modes that SQL Server supports, and nested transactions. In that article I stated “…just placing several SQL commands between a BEGIN TRAN and a COMMIT or ROLLBACK does not ensure t

(Steven Warren) In my last article, we went over how to install SQL Server 2005 and what it entailed. In this article, we will continue by giving you an overview of what the new interface looks like. Let’s begin by exploring the menu bar as shown in Figure A.

(Ravindra Okade) SQL Server 2005 brings a host of new features to the table. Ravindra Okade details a couple of nuggets that are not easy to find but can be very useful to every developer and DBA. Synonyms are very handy for managing database objects. And non-clustered index included columns, althou

The following issue is fixed in this Microsoft SQL Server 2000 hotfix package: You experience one or more of the following symptoms on a computer that is running Microsoft SQL Server 2000: • SQL Server 2000 stops responding to incoming logon requests or to query execution requests. • You exp

When you use the Bcp.exe (BCP) bulk copy utility in Microsoft SQL Server 2000 to import or to export data, you may receive an error message that is similar to the following: SQLState = S1000, NativeError = 0 Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Code page <codepage> is not suppo

(Dina Fleet Berry) Moving or copying a SQL Server database from one machine to another requires a lot of preparation in order to ensure a smooth transfer. When moving from SQL Server 7.0 to SQL Server 2000, there are 4 choices in how to implement the transfer: –Backup and Restore –sp_detach a

(Brian Kelley) One of the biggest performance gains built into SQL Server is the stored procedure. SQL Server has the ability to cache the execution plan for re-use at a later time. While SQL Server 2000 has improved tremendously in caching execution plans for ad-hoc SQL queries, it still hand

In the previous lesson, we saw that a table provides a good technique of organizing a list of items and to store the list in a database file. To create a table, you can type the expression CREATE TABLE followed by the name of the table.

(Venkat Prasad) This article discusses some programming techniques for saving XML data from Microsoft SQL Servers, Web Servers, XML Web Services, and Microsoft SQL Reporting Servers. Topics include a comparison of traditional techniques used for saving XML streams, using ASP/ASPX and COM, with n