Why would you say that?

I'd say B. Dates should be stored in datetime columns, not seperated out. There are a couple of good reasons

There are some quite powerful...

First I would suggest turning off the autoshrink. That will try and shrink both the data and the log files.

In simple recovery mode, the transaction log will grow to a...

They're in a different database to the one you're in. Look at the DB_ID.

If you're using SQL 2005 SP2, you can use the enhanced version on object_name that takes...

Who gave you the right to order people around here?

And please lay off on the...

If you want a SQL...

Nice. I'm also a little tired of people looking for a free lunch.

Problem is, those who need it most will likely not be the people who read it.

SET NOEXEC ON

Run the query.

With noexec on, all SQL will do is parse and compile the query. If it encounters syntax errors, you'll get the error back.

I could be mistaken,...

Thanks. Will let you know afterwards how it went. I'm not looking forward to it, since admin's not my main job function.

In your case, probably because the column is not nullable, or because there's an index on that column and SQL's decided that it's the best way to do the counts.

If you've never done a full database backup since switching to full recovery mode, the log will auto-truncate as if it was in simple recovery mode.

Fairly simple reason. Without a...

When SQL gets restarted? None of the caches are persisted to disk so all are empty when SQL starts up.

I wouldn't recommend doing either on a production server, certainly not...

Ha! Found it. That had me stumped for some minutes.

You're missing an END. There's a BEGIN on line 7, but no matching end. Put the END after the last EXEC...

Very strange. Also getting syntax errors when I get management studio to do a syntax check.

I had a reason for writing those, but now I can't...

It's always recommended to update the stats on all tables after an upgrade to SQL 2005.

2005 keeps more detailed column stats and while the optimiser can use the SQL...