What does the PAD_INDEX parameter do when you...

You are examining a SQL Server 2005 system...

Overview and Installing SQL Server 2005 SP2

In this presentation Brian shows you some of the new features in SQL Server 2005 SP2. Then, he demos briefly how to install SP2 and some of the small quirks around the installation.

SQL Server 2005 Backups

If business today is data, then the entire enterprise is in the capable hands of you, the SQL Server DBA. Before you panic, check out Grant's detailed dissection of SQL 2005 backup and recovery regimes.

Which database holds the tables that Database Mail...

First Look: SQL Server 2005 SP2 CTP

Service Pack 2 for SQL Server 2005 is not quite here, but Wayne Fillis brings us a look at what you can expect if you install the CTP version that is available now.

You are wondering if your indexing scheme for...

What is the recommended way to send mail...

You setup a linked server from a SQL...

Automated Monitoring Database Size Using sp_spaceused

Keeping track of the amount of space in a database is something every DBA needs to do or face the dreaded "out of space" errors appearing on every client's desktop. SQL Server guru David Poole brings us an automated way of doing just that.