How many extents can fit into a megabyte...

New JDBC Driver for SQL

This is one of the vendors we met at PASS 2003. Their new driver is supposed to be faster than the driver provided by Microsoft AND supports NT authentication. Link takes you to a comparision chart of features. (Not Reviewed)

You have 1,000,000 records in your customers table....

Custom Log Shipping

One of our favorite authors is back with a great how-to on log shipping. This isn't the baked in log shipping, this is a code your own solution that gives you a starting point for your situation. Even if you don't need it now, it's worth looking at to gain a better understanding of how shipping works.

In SQL Server 2000, where would you go...

What is the maximum amount of RAM SQL...

The Guru's Guide to SQL Server Architecture and Internals

New book! This new book by Ken Henderson (author of other 'GURU' books abou SQL) promises an all inclusive approach to the internals. Sample chapters and other info available by following the link. We'll try to get a review up soon!

Your SQL Server 2000 machine has been mysteriously...

What do SQL Server blackboxes do?

Transferring a SQL Server Diagram

So you've created a diagram that you now need to transfer to a different server or database. This article will show give you a step-by-step guide on how to do this.