Alter Table is the only way to add an identity column to an existing table.

Other methods involve copying the table (usually to a temp table), dropping it, recreating it, and...

The "hot spot" thing has been fixed for a while. I think since SQL 2000. Not so much of an issue these days.

I'd say the bigger issue to...

Server groups are server groups. If they have members, they might end up being in use.

It means one or more rows are returning something that can't be converted into a big integer.

You might be able to use IsNumeric to find which rows.

If you post it on Microsoft Connect, people can vote for/against it, and Microsoft gets the suggestion there.

Windows can only pass authentication keys from one computer to one other, it doesn't allow chaining them. So, if you use Windows credentials to log in to a workstation,...

K. Brian Kelley (11/17/2010)

---

Lynn Pettis (11/17/2010)

---

Anyone who claims to be a 10, imho, is either a liar or too full of himself (or herself) as it is simple arrogance. ...

Only nothing to worry about if it's not a hardware problem that's going to get worse. I'd at least run diagnostics on that.

Yeah, that works too. I was just talking about reading error messages in SSMS, but getting an actual error value makes more sense for what you're looking for.

You're welcome.

Ah. That makes sense then.

Have you looked at performance monitor to see what is taking up time? Is it running into memory pressure issues?

There's always a point, beyond which, no amount of optimizing anything has any measurable positive effect. There's also a point where the cost of increasing the optimization exceeds the...

Stefan Krzywicki (11/16/2010)

---

Alvin Ramard (11/16/2010)

---

Chris Morris-439714 (11/16/2010)

---

No idea, Wayne.

That really...

Yeah, I confused it for a moment with the sys.columns view. Should have looked before I posted.