I voted for both of them. Good thought there, Steve. SP3 for 2005 took that kind of nudge to get going, better to act now on this one...

James Stover (12/27/2009)

---

I'll go one further - I don't think it's acceptable to have service packs. It's an acknowledgement that a product is defective. Only after an unspecified number of...

Christmas isn't that important a holiday to me. I like the day off, and it's fun doing presents, but it doesn't have a religious significance nor importance to me....

Steve Jones - Editor (12/24/2009)

---

I'm not sure I'd advocate skipping them, but they could be low key, take an afternoon off, potluck, and small recognitions at work, just to remind...

Investing in employee loyalty and morale is an investment in company profits and can have a significant ROI. Has to be managed correctly, but it can be done.

It can...

I will run stat updates after index reorgs (not rebuilds, would be redundant).

This question assumes I ever mentally checked...

Matt Miller (#4) (12/23/2009)

---

Roy Ernest (12/23/2009)

---

I am working...Tomorrow I am OFF. Monday I will be back to work till Wednesday. Then I am off again. After that it will be...

1 PM here. Still working. 4-day weekend starts tomorrow. Might sneak out...

Steve Jones - Editor (12/23/2009)

---

Lots of adds and deletes can do it. Our AV program would add in 10k+ every time, and I think it trimmed out values older than...

I haven't done a multi-instance in-place upgrade, so I can't say what to do technically. What I would suggest is contacting Microsoft support directly.

I've done in-place upgrades, but only...

Try a script like this in your dev/test environment:

alter table dbo.MyTable

drop column ID;

alter table dbo.MyTable

add ID int identity (-2147483648, 1);

It will give you errors if there are constraints or indexes...

The system views (DMVs) won't give you data particular to that time period. They will give you a lot of very valuable data, but it's since last service start,...

Resetting the ID with checkident can cause problems. Take a look at checkident in Books Online for the details.

Dropping and re-creating the column allows you to reset the starting...

If the column really isn't used for much, you could probably drop it, re-create it, and seed the start value at -2,147,483,648. That gives you twice the range for...