the owner of the job, if I remember, doesn't do much in 2000. I think it can only be logins, and I've just used SA as the login.

It seems...

Richard,

Excellent points, and some of that is trying to be addressed with Sharepoint integration. I'd agree there are issues, but that's not a reason to ignore Excel, especially when a...

http://www.sqlservercentral.com/articles/Clustering/65994/

http://www.sqlservercentral.com/articles/Clustering/66246/

Very well put, Jeff. There are multiple ways to handle inventory, and modeling is not something you learn in a day. It takes time, and if you've never done it,...

I'd tend to agree with Jeff. You can secure this pretty well these days, and in limited use, it makes sense. I wouldn't want someone to have unbridled access, especially...

Are you sure the table contains only 7000 rows? Or are you looking at rows that have some value with a where clause?

If there are only 7000 rows, I'm confused...

Data warehouses tend to grow pretty well. Why both to shrink? If you needed 45GB at one point, won't you need it again relatively soon?

If there is a space issue,...

Everyone is replaceable, but not easily replaceable and I'd like to think that most people have value at their jobs. If you treat them as if they are easily replaceable...

Dell had some cheap ones, and you could check eBay for something used.

You can use virtual servers and share the disks that way.

You could use snapshots if you have Enterprise edition, but if you need to restore or something happens you'll lose them.

A better solution would be calculate this stuff and store...

You can write triggers to catch updates and deletes on specific tables if you want.

You can limit SQL using the affinity mask, but AFAIK, this doesn't affect licnensing. If you have 2 CPU sockets filled in the machine you need to license both of...

I'm not sure the diffs help you here in that you would likely fail to the standby, not recover the primary. If you then wanted to fail back, you're have...

It doesn't increase the space, but it does fix any reporting issues from the deletes.

The dev db is never the master. VSS is the master. You start by pulling everything into VCS from the production db, then you deploy to the dev db from...