Andrew - I wouldn't go hog-wild and start changing everything - but I would definitely ask them if you can change that particular setting. I can't imagine how that...

In short - yes. That's the right way to do it.

Why buy when you can evaluate?

http://www.microsoft.com/downloads/details.aspx?familyid=D5C12289-F4E4-49A9-9235-AB2F6D4CA097&displaylang=en

You'll need a bigger machine though....:) It takes a rather massive chunk out of your machine (it's essentially a customized sharepoint install running on...

TFS = Visual Studio Team Foundation Server. It's a bear of a product: version control/project management/project documentation all rolled into one. And all that for a bear...

Well - since you have a source control/version control solution - it's now time to "incentivize" using it. Meaning - lock your developers out of prod. The only...

this is also not automated - but running a "generate scripts" task once a week would give you a quick benchmark. You coud use something freeware like WinDIFF to...

Jack Corbett (3/5/2008)

---

Matt Miller (3/5/2008)

---

I used to throw something like that into my Email signature.

It looked something like:

After I had been using it for a while,...

I am opposed to messing with the values of UID's (assuming they're being used as Primary keys, etc...) The ripple effect of that kind of update on all foreign...

Rishi -

Glad it's been useful. I learned a lot from it for myself...

If it's at all like other SP installs on a cluster, you patch the cluster, and the cluster "pushes" the updates to both nodes. Thus the need to keep...

I used to throw something like that into my Email signature.

It looked something like:

After I had been using it for a while, I got quizzed by...

Jeff - true enough. It would make that tough in the absence of surrogate identifiers. Of course - I then plan "other ways" to get those (like a...

Keeping in mind that datetime fields always store both date and time components no matter what (at least until you get to SQL Server 2008 with its new data types)...

Jeff Moden (3/5/2008)

---

Grant Fritchey (3/5/2008)

---

FWIW, I put two people through phone screens yesterday. Both had more than 8 years experience in SQL Server. Both were listed as senior level consultants....

TheSQLGuru (3/5/2008)

---

Gotta disagree with you on the autoupdate stats being off statement. There are indeed a few huge production systems out there where autoupdate should be disabled, and also...