Missing Temp Tables
In part one of a two part article, Andy Warren challenges the readers of SQLServerCentral.com to solve a problem involving ADO and SQL Server. Are you up to the challenge?
Scrubbing Data With DTS : Part 1
When trying to implement data from an external source, very rarely do you receive the data in perfect condition. In part one of this series, we show you how to clean your data using DTS.
A Windows 2000 Service Pack 2 Update
Getting ready to install Windows 2000 SP2? Read this article first. It provides links to resources as well as potential problems.
MesaureUP Test Prep (70-029)
Review of the MeasureUp test preparation serivce actually used by the author for the SQL Server 7 Design exam(70-029).
SP_MSFOREACHDB - Getting a list of databases via TSQL.
Sp_MSforeachdb gives a DBA the ability to cycle through every database in your catalog. Find out how to use it.
SQL 7 Bugs on SMP Servers
SQL Server 7 has a number of bugs that occur on multi-processor machines. This article presents a concise listing of these bugs.
A Look at SQL Server CE
An introductory article from Microsoft on the newest version of SQL Server: SQL Server CE designed for Windows CE devices. Includes some ideas for where this version fits in your architecture.
ANSI Joins
Are you confused by all this inner join style syntax that is becoming more and more prominent lately? This article by Neil Boyle will help you find your footing in the ANSI join syntax.
SQL Server 7.0 and 2000 Clustering Resources
A good place to start before clustering. Written by Brad McGhee, the founder of sql-server-performance.com.
Your Friend the Computer
You know it is time to reassess your relationship with
your computer when....
Blogs
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
Forums
A Challenge of Our Knowledge
Comments posted to this topic are about the item A Challenge of Our Knowledge
The memory toll of VARCHAR(MAX) in SQL Server
Comments posted to this topic are about the item The memory toll of VARCHAR(MAX)...
Question of the Day
Transaction Log Truncation
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers