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.

OK, attempted to correct the answers to include A and B. The old style question and new interface make this an iffy proposition.

Everyone awarded points for this one.

What happens on the way down? I think I'm glad you're not building them either,...

User

----

ID

Name

IsVendor

IsCustomer

IsEmp

Not the best solution, but it works.

Or you have

User

------

ID

Name

UserLink

--------

ID

IsVendor

IsCustomer

IsEmp

Sorry, I meant internal, meaning you don't need variables that you use in the SELECT. Guess it could apply for interval variables.

You could use a CTE if it makes things...

I've heard good things about NetApp products, but haven't really worked with them, so no firsthand experience.

The vendor wants to sell the thing. They'll always say performance isn't a problem,...