Why the SQL Server Optimizer Uses a Nonclustered Index Instead of a Cl

Interesting info about why the optimizer might choose to use a nonclustered index over a clustered index. Links to two other articles that cover each type of index in more detail.

Review of AdeptSQL

Another product review! Chris put AdeptSQL (a schema comparison and sync product) to work and wrote up the results. This article also includes some feedback from the vendor that is worth reading.

Email and Yukon - What Changes Would You Like?

Microsoft is soliciting input on email functionality in Yukon. Follow the link to complete the survey. You can also discuss it here on the site:

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=17739&FORUM_ID=9&CAT_ID=1&Topic_Title=SQL+Mail+and+Yukon%2C+what+do+you+want+to+see%2E%2E%2E&Forum_Title=General

Updated Yukon Info from MS

This page has some newer information on Yukon. Worth looking at!

Overview of 64bit SQL

New Author! This is a great article, seems like it covers almost every question you might have about installing and using the 64 bit version of SQL2K.

It Cant be Done with SQL

New Author! This is a great walkthrough that starts out with a description of the problem and goes all the way to the solution - all using TSQL.

How to use the new function fn_get_sql() ?

This article shows you how to use the new function fn_get_sql() and the 3 new columns of master.dbo.sysprocesses. These changes were introduced in SQL Server 2000 SP3/SP3A. In this article, you will find a general purpose stored procedure called ShowCodeLine. It makes use of these new features, to inspect a given spid, and display the currently executing line/query

Design A Database Using an Entity-Relationship Diagram

New Author! Ramesh talks a little about database theory, using the ERD, and how you can put it to work.

Cycling Those Error Logs

Have you ever tried to open the current error log in Enterprise Manager only to have it seize up and hang? Has that annoyed you? It certainly annoyed Steve Jones and he decided to do something about it. A little techinque for helping to manage the size of those logs and prevent the "not responding" message from appearing in Task Manager.

Code Stored in Files Instead of Stored Procedures

This articles proposes storing the source code for stored procedures on disk rather than in the database itself, the intent to give developers the ability to easily change them or potentially to allow third party encryption of source code. (Note from SSC: If you choose to implement a technique like this, please be sure you understand the implications of exec'ing strings)