SQL Server ships with a built in system...

What does the STATS_DATE() function do?

Distributed Partitioned Views / Federated Databases: Lessons Learned

This article contains information about the things we have learned while working with Federated Databases. Before beginning it is necessary to define the terms being used. Included in this article is one solution in production that is using federated servers and Distributed Partitioned Views.

Deploying Reports

Longtime SQL Server expert Raj Vasant takes a look at various ways in which you can deploy reports for Reporting Services 2005.

If you run a backup to your local...

How can you get the number of columns...

Upgrading a Database SQL 2000 to SQL 2005

Performing an upgrade to the next version of SQL Server is something more and more of us will be doing as the support for SQL Server 2000 wanes. New author Sachin Samuel brings us an overview of the process and options that you have for performing an upgrade.

The Differences Between SQL Server 2000 and 2005

What are the differences between SQL Server 2000 and 2005? It's a question that DBAs are often asked by those who don't work with SQL Server on a daily basis. Steve Jones begins a short series on the differences by examining some of the core administrative differences.

Starting SQL Server in Minimal Configuration

Have you ever misconfigured your SQL Server's memory and been unable to start it? That happened to new author Jay Dave, who has the Data Center edition of SQL Server 2000 with a whopping 36GB of RAM. Here's how to get your instance back up and running.

You restart your SQL Server on a Sunday...