Software Spotlight by Brad M. McGehee – Wouldn’t it be great if there was some way to not only reduce the size of SQL Server backups, but to also speed them up. As a matter of fact, I am not the only person to have this problem. The good people at DBAssociates, in Melbourne, Australia, also had this

In this article, Alexander Chigrik explains some problems that you can have whenyou set up replication. He also tells you how you can resolve these problems.

By Michael Garstin – For a rapid way to add a comment header to your code from Query Analyzer, add a “comments.tql” file to the Query Analyzer Templates sub-directory.

By Russ Whitney – When you’re analyzing terabytes of data, the performance of your CROSSJOIN() functions can make–or break–your application’s overall performance.

By Kalen Delaney – Inside SQL Server 2000 was published in November 2000. As an update to my 7.0 update of Ron Soukup’s best selling 6.5 version, it is intended to fill in many of the gaps left by the online documentation dealing with how SQL Server actually stores and processes data internally. It

The SQL Server 2000 Full-Text Search Deployment white paper is for database administrators who have to deploy full-text search applications, currently use full-text search, or want to explore what full-text search offers. It outlines the hardware and operating system requirements for efficient full

By Andrew Georgopulos – Databases are complicated because they have so many interdependent elements. The components’ interdependence is most evident when trying to improve server performance. When things slow down and performance seems to flag, organizations tend to look at the server as the source

by Joe Chang – If you can’t wait until the final version of this article on INSERT, UPDATE, and DELETE costs in SQL Server, this preliminary article on INSERT costs is a good start.

By Ellen O’Brien – When the call went out for DBA bloopers, Christopher James Thompson sent a whopping five memorable blunders. Is he more accident prone that most DBAs? We doubt it. Thompson is probably just more honest. Here Thompson recounts two of his favorite bloopers for SearchDatabase.com rea

One of the most asked questions involves a bit of code like this: Select * From Products Where ProductID in (@SomeCSVString). I’ve always said the only way to do this was through dynamic SQL. Actually there’s a better way in SQL Server 2000. It doesn’t involve dynamic SQL and it’s really easy to use