SQL Server Magazine columnist Itzik Ben-Gan shows you a few tricks for set-based analysis of data relationships using the NOT EXISTS() predicate.

by Jill R. Aitoro – In an effort to appeal to the commercial gaming industry, To-Paw Software needed to find a way to speed up the database connections and improve performance of the simulation engine for its interactive soccer manager program.

By Brian Moran – Most SQL Server customers use tempdb a lot without realizing that heavy use of tempdb can cause resource-allocation contention and result in potentially serious performance problems. If you think tempdb is slowing down your system, check out this article.

Download the updated documentation for Microsoft SQL Server 2000. SQL Server 2000 Books Online (Updated – SP3) includes the complete documentation that shipped with SQL Server 2000 plus revisions.

My company is setting up a disaster recovery site, and plan to install SQL Server on a new computer. The Microsoft Windows NT® administrators want to use the computer running SQL Server as a primary domain controller (PDC). I have heard that this setup is not a good idea because of the resource-inte

Learn best practices for collaborating with developers to set up development, test, and production environments; streamline processes; work with source control; secure applications; and more.

by Paul Mandella – Check out this and other tips at SearchDatabase.com.

If you’re having trouble with bulk copy, check out these 14 tips from Alexander Chigrik.

This question comes up quite often in the newsgroups. Here are the steps to getting this setup.

This process will import text files that arrive in a directory into a table. It will process every file in the directory with the correct filemask and move the file to an archive directory on completion. It can be used in conjunction with an ftpget SP to import files from a ftp server (see ftp).