This example combines dynamic SQL, BULK INSERT and the proper handling of double-quotes to solve a client's problem with loading various text file formats into a database.

Here are SQL Server Magazine’s monthly, Web-only series of SQL Server tips brought to you by the Microsoft SQL Server Most Valuable Professionals (MVPs). Microsoft introduced the MVP program in the 1990s to recognize members of the general public who donate their time and considerable computing skil

This article by Justin Gunther will show us with the advent of XML, we have the ability to supercharge our websites with huge performance increases. XML allows us to separate code, content, and presentation. Web developers now have three separate files which in turn will create the HTML that we outp

Microsoft's Jyothi Pai, a SQL Server support professional, will host a WebCast about SQL Server 2000's multiple-instance support Thursday, March 22, at 10 AM (Pacific time).

Software Review by Brad M. McGeheeMonitoring a SQL Server-based application's performance, whether its one you have purchased off-the-shelf or have written in-house, is a complex task involving many variables. But when it comes right down to it, it all depends on the user's perception of

Red Gate Software has released new versions of SQL Compare and SQL Data Compare for database comparison and synchronization. SQL Compare will synchronize the structure of SQL Databases. It now has improved SQL 2000 support and a number of other enhancements.

By Rob HawthorneGet out your long forgotten secret decoder ring, as you will find it handy when reading this new book on SQL Server 2000 development. In this book, you will learn how to design, create, develop, and manage a database application you can use to manage your own private spy network.

By Dave HulseOne promise of the XML standard is that it will provide data streams that are not only platform independent but also vendor (or organization) independent. For example, a healthcare industry standards group is attempting to develop XML message formats that will allow data sharing thr

by Brad M. McGehee If you have much experience with indexes at all, you are probably already familiar with the difference between clustered and non-clustered indexes. But this article is not about them. This article is about whether or not the SQL Server Query Optimizer will use your carefully

(Carl Nolan) SQL Server 2000 includes many new features that extend its capabilities as a high performance relational database system with a rich development environment. This article presents an overview of new product features including AWE support, new data types, new user-defined and built-in fu