Two weeks ago Andy challenged the readers of SQLServerCentral.com to figure out a small puzzle. Come see the results for yourself and find out who won some cash!

Undocumented T-SQL Tricks With Logs

by Brian Knight

SQLServerCentral.com

Administration

An interesting feature added to SQL Server 7.0 and 2000 is the ability to purge
an error log through a stored procedure or DBCC command. In this article, Brian Knight shows some of the undocumented stored procedures to detect, read and purge an SQL Server error log in T-SQL.

Locking in SQL Server 6.5

by Alexander Chigrik

SQLServerCentral.com

Performance Tuning

This article examines how locking occurs in SQL Server 6.5

Optimizing SQL Server Performance Using Files and Filegroups

by Additional Articles

SQL Server Performance

Performance Tuning

Learn how to boost the performance of SQL Server by making proper use of filegroups.

SQL Server 2000: New XML Features Streamline Webcast

by Additional Articles

Microsoft MSDN

With XML support in SQL Server 2000, you can query SQL over HTTP with a URL, bring the data down to the browser, and manipulate it on the client machine. By adding Internet Explorer 5.0 to the mix and using XSL to convert the XML to HTML, you can lighten the load on your database server. Going still one step further, by using Vector Markup Language you can even create drawings on the fly using the data from your SQL queries.

Transact SQL Programming

by Steve Jones

SQLServerCentral.com

Book Reviews

Steve Jones reviews of this reference.

Automate Writing Stored Procedures

by Additional Articles

DevX

Stored Procedures

This article by David Rabb from the June 2001 issue of VBPJ shows you how to build a tool that will build a select, insert, update, and delete stored procedure for each table in a database. It's a great example of how to use DMO and a great tool as well!