To help you design Microsoft database servers that must achieve the best possible performance, Inside Microsoft SQL Server 2000 has the details you need. For one thing, author Kalen Delaney (who used Ron Soukup’s fantastic first edition as a starting point) explains how SQL Server 2000 works at a le

Q. How can I create a plain-text flat file from SQL Server as input to another application?<br><br>A. One of the purposes of Extensible Markup Language (XML) is to solve challenges like this, but until all applications become XML-enabled, consider using our faithful standby, the bulk copy program (b

In this article, Alexander Chigrik describes general concepts concerning validating data for Transactional replication using SQL Server. He then provides a step-by-step guideillustrating the data validation process.

Q. Why do I have to give permissions on the underlying database objects when I’m using dynamic SQL statements? A. These permissions are required for security reasons. Consider the following simple stored procedure:

(Greg Robidoux) Selecting the recovery model and backup options can be simple for your SQL Server implementation. The best scenario is to select the options that provide the most flexibility. The following are some guidelines that can be used for selecting the appropriate backup and recovery model a

From SQLTeam – This article comes to us from Bill Twomey. Bill writes “I had to automate a daily extract process. This job had to extract a set of records, and deliver them to a remote system. At first this seemed like an easy task, but the requirements of outgoing transfer, a new filename each day

By Ellen O’Brien – Experienced DBA Peter Gooley had to dig deep in his memory archives to come up with his favorite blunders, mistakes that make him laugh today, but were not so funny then. He shared his two blunders, one that started as a mystery and another that began with bored DBAs playing silly

In his latest article, Alexander Chigrik offers twelve useful tips for ensuring that you’ve constructed your SQL Server stored procedures to perform in the most efficient manner possible.

By Itzik Ben-Gan – When you need to perform calculations that don’t necessarily involve accessing data that’s stored in tables, take the logical path to a solution.

In this article, Sergey Vartanyan shows you the core differences between SQL Server 7.0 and 2000.