Please don't cross post.

The Monthname function will get you the month name, you can use datepart to extract the others, and then concatenate the strings together (CASTing required for the...

Once you have the month, you might need to use the Monthname function to get the full name. Look up date functions in Books Online.

The subquery allows you to find the date you want, the correlation does it for each client.

It's the way I'd do it as well.

Assuming you have downtime, you need to have both sets of storage visible to the server. This would allow you to "detach" and attach" the databases.

- You would "detach" the...

It will support quite a few, mainly dependent on you storage hardware. There's no good answer to this question as the type of query, complexity, indexing, as well as hardware...

I think there's a way to do this with a trace flag or registry setting.

http://www.mssqltips.com/tip.asp?tip=1457

The problem is that you update the table, the transaction was written to the Tlog, then a minute or two later, it was truncated, and so the data is lost.

Doing...

Not a bad idea. We'll talk about it next week.

Wow, :blush: thanks

My first guess is that you've got a query or process that runs periodically, maybe something someone kicks off, that kills the server. Maybe a long cross join.

I'd run Profiler,...

That sounds strange.

Can you capture a simple example, save off the two plans and attach them?

I don't think you can in SS2K. Quite a bit of that information wasn't exposed at all in SQL 2000, so without a debug version, not sure it's capture-able.

One of...

I think they don't matter as much. In '97 or '98, you could get an MCSE and be assured of a job (almost) making $50k. A lot in those days....

That's something I point out in interviews.

I don't know everything, but I usually know where to find it. Either a resource online or a person I can ask.

I'd start with a variable,

declare @start datetime.

Set that to be the "date" of a year ago using Dateadd. Use months, -12.

Then in your WHERE clause, use the variable.