SELECT CASE WHEN @checked IN ('Y', 'True', 

IIRC, there are few topics in 2072A (the MS 5-day SQL Server admin class available at most training centers) that don't make the trip to SQL Server 2005.  There are...

The restored database will use the original file sizes.

DBCC SHRINKFILE is the way to go.

I'd advise taking a full backup first, expanding the log file considerably and taking a log...

Ensure that the constraints are being created using WITH CHECK instead of WITH NOCHECK.

You can see how this affects your sample code by doing the following:

1.  Run your sample above...

1.  Snapshot reporting refers to read-only access of database snapshots created on a mirror server (SQL Server 2005 Enterprise Edition).  Mirrors and snapshots are new to SQL 2k5.  The scenario...

The key part is that when the CHECK constraints are created, they perform the 'check existing data on creation' step.  If you build them with EM, that isn't done by...

That 'touch' is part of normal query resolution: the table schema is validated during parsing - which occurs before the WHERE clause is hit.  The table data is not queried.  Thus...

Float and Real columns hold approximate data.  The value you try to store in it may not be the value that is actually stored.  While there are valid uses for...

To count sub-sets, use CASE to make your different tests.  For each test, the CASE should return 1 for true, and 0 for false.  Then you can just sum() the results,...

Could you post a little DDL and sample data to help us out?

Are you using SQL Server 2005?  One query does the trick:

-- Set up sample data
DECLARE @Source table (CostId  

In SQL2005, you could roll a UDT and include a column of that type in your table.

Under SQL2000, the only way to get both in a column is with a...

  In a Server + CAL environment, SQL Server does not keep count of CALs used.  Remember: a User CAL licenses a user for an unlimited number of connections, a...

Take a look at the master.dbo.syscacheobjects table.  This is a virtual table that will list every compiled plan in the cache for every database on the server.  Any currently-compiled procedure...

Time for some overkill with the new stuff   I mixed some XQuery with an UNPIVOT

-- Prep the sample data
DECLARE...