Sorry about being unclear. I'd like to see the t-sql you would use to update the production database zip table given its current state and the previous zip data (assumed...

Both responses were excellent and helpful. Thanks.

Bow wow!

Thanks for your answer.

Barkingdog

I bow (and bark) to a superior sql coder. I like your idea too.

Barkingdog

Great! I didn't know about EXCEPT!

3 barks and a tail wag.

I never met a fire hydrant I didn't like.

Woof woof!

Thanks.

Amazingly simple! 3 woofs and a tail wag.

I was under the impression that using "replace", even as a test, would actually cause the replacement to take place in...

Interesting ideas.

What is the "recommended" approach -- enabling page level locking for index reoroganizaiton or not?

Barkingdog

>>> why don't you add some disks and split the DW database to a seperate array?

That's exactly what I did as query governor didn't offer me what I wanted.

Barkingdog

I found a free tool (caled Sqlpermissions) from Idera that looks like it could do the trick:

http://www.idera.com/freetools/

Case closed.

Barkingdog

Suppose we have a decidated x86 sql 2005 box with 4GB or RAM. What would you limit sql server to? (around 3GB?)

TIA,

Barkingdog

I thank everyone for their help but I think the winner was making the "delete files older than N days" the first step in the job.

Barkingdog

Multiple sql instances on one box can be useful for sql server consolidation. (Seems better to me than having multiple virtual machines, each housing a single sql instance, on a host.)

Barkingdog

Steve,

You wrote "You can break up the insert as well,".. I sense what you me but could you please show me an example of what you are referring to?

Barkingdog

P.S....

We are looking at purchasing a NetApp SAN and don't know much about the whole subject.

1. What exactly is a LUN? Can a LUN hold, say, 50% of a drive's...