Let X be a node in a nested...

Don't Upgrade to SQL Server 2005

It's been almost three years since SQL Server 2005 was released and Steve Jones current recommendation is that you don't upgrade right now. Read on to see why he's giving this advice.

Pop Rivett and the Expanding Log

When your database transaction log is out of control, there is only one man who can tame it.

How do you convert a floating-point value from...

Monitoring Changes to your Database Schema

With the introduction of SQL Server 2005, Microsoft now allows you to write Data Definition Language (DDL) triggers to perform actions when events occur on your server. In this article, Greg Larsen discusses (examples included) some of the things that DDL triggers can be use for.

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...