When you use Microsoft ODBC Driver for SQL Server to fetch data in asynchronous mode, you may see that the data that is fetched is corrupted for some of the columns. This corruption does not always occur, and is random in nature. Most of the time you see that some columns of the last row that is fet

(Alok Vyas) This script is used to read the data from a flat file and then populate it into the database table. (script)

Well it has finally arrived, at least in the Beta version. Microsoft’s long awaited latest version of it’s SQL Server product has arrived in Beta version and holds promise to be a major and successful revision of this fine product. I have had the Beta version for a few months now and one of the new

(Randy Dyess) Among the changes brought to you by the next version of SQL Server is the ability to tie SQL Server login passwords into the Windows 2003 local policy for passwords. This ability allows SQL Server login passwords to enjoy the same complexity and expiration policies long associated with

(Christa Carpentiere) The aim of this article is to give you the key pros and cons of using stored procedures to encapsulate the Transact-SQL (T-SQL) needed by your applications, so you can make an informed decision about using them in your environment. For those who can take advantage of them, I wi

Here is a completely dynamic version of my paging technique in the form of a stored procedure. Just pass in a short SQL statement, the Order By clause, and the start row and end row you’d like to return in the resultset. The stored procedure then will process your SQL in the order specified and re

(Itzik Ben-Gan)Secrets are always intriguing, and programming back doors—secret entrances into application code—are no different. I’m covering T-SQL back doors lately for several reasons. First, programmers frequently use undocumented features, which you need to be familiar with in case you need to

One of the best ways to boost JOIN performance is to limit how many rows need to be JOINed. This is especially beneficial for the outer table in a JOIN. Only return absolutely only those rows needed to be JOINed, and no more.

(William Pearson) In our last article, The Authoring Phase: Overview Part I, we began an overview of the first of the main phases of the enterprise reporting life cycle. We introduced the article with observations surrounding the objectives of the MSSQL Server 2000 Reporting Services series, as well

This document describes the steps required to configure replication from Adaptive Server Enterprise (ASE) to Microsoft SQL Server (MS SQL Server), and from MS SQL Server to ASE. These steps involve configuring the following products: a) ASE b) Replication Server c) DirectConnect for MS S