In SQL Server 2000 Profiler, the numeric value...

There is the data in the People table:

foo_id...

SQL Server 2005 has a number of T-SQL...

Incident Response - Responding to an Incident

Part 2 of Steve Jones' Incident Response series that looks at how you should be prepared as well as what to do when disaster strikes. Part 1 established a basic framework and part 2 dives deeper into what you might need for the next virus, hardware failure, or hurricane :(.

Keeping QA Up To Date - Part 2

Working with a QA server in SQL Server 2000 is something everyone should learn to do. Having some staging area between development and production will help ensure a more stable environment and smoother deployments. After a little hiatus, Steve Jones continues with this series looking at moving the latest backup over to QA.

The SQLServerCentral.com Move

It was an adventure. Moving a SQL Server physically from one location to another should be a simple process, but it turned out to be a bit more than Steve expected. Read about the adventure and inject a little humor into your day.

What does ACID stand for?

SQL-DMO can be used from which of the...

Can you please define covering indexes?
Submitted by Ronald...

Your database includes the following two tables:

CREATE TABLE...