What are the advantages/disadvantages of using global variables in PL/SQL packages? I have created tons of packages and stored procedures, but have never used global variables.Any insight or links ...

There are various ways of using global variables in Microsoft SQL Server 2000 DTS Designer tasks. This article, one in a series, looks into their role in exchanging data between packages, using ...

Learn how Data Transformation Services (DTS) can help you import, export, and/or transform data from various sources to single or multiple locations in Microsoft SQL Server 2000.

When you use index views in the right situations, they can dramatically improve the performance of SQL Server queries. Tim Chapman explains why performance testing is the best way to tell if ...