Assuring optimal performance of database applications starts with coding properly formulated SQL. Poorly written SQL and application code is the cause of most performance problems. As much as 75% of ...

Learn how to master the SELECT statement to form truly useful data queries. This article explains functions, clauses, and keywords that will make your life a lot easier.

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.