Using XP_EXECRESULTSET To Obtain Database Size Information and More

Have you ever used XP_RESULTSET in SQL Server? If you're like most DBAs, this procedure is rarely used and can be a little complicated to setup. New author J. T. Shyman brings us a look at just how useful this command can be in executing a command on every database.

Working with TempDB

This white paper describes how SQL Server 2005 uses tempdb. Many improvements in SQL Server 2005 optimize tempdb usage and make it easier to manage and to troubleshoot. A case study that uses a workload similar to TPC Benchmark H (TPC-H) shows new ways to manage and troubleshoot tempdb resources. This paper also includes items to consider when upgrading to SQL Server 2005 and configuring tempdb

Management Studio with SQL Server 2000

SQL Server 2005 has a new administrative tool called Management Studio, with many enhancements and changes from Enterprise Manager. But it's not just for SQL Server 2005 as new author Rob Farley shows us how to use this tool with SQL Server 2000.

You are trying to track down issues with...

SQL Server 2005 - Unattended installation - Part I

Automating the installation of SQL Server was made simple in SQL Server 2005. SQL Server 2005 can be installed using a GUI, an ini file or just run setup.exe with a bunch of parameters.

When testing connectivity in SQL Server, you use...

Reap the Benefits of SQL Server's New Database Tuning Advisor

The Database Tuning Advisor (DTA) is an improvement over the old Index Tuning Wizard. Learn how to access the advanced features of DTA from the command line with a custom configuration.

You have a relatively new SQL Server 2005...

Which of the following services is instance-aware?

Quickly Viewing Available Space

As everyone moves to SQL Server 2005 from SQL Server 2000, there are quite a few pieces of information that have moved and may give you trouble finding. Boris Balinger brings us a followup to his first look at some of those changes with a quick article on how you can get the free space in your database files.