SanjayAttray (8/16/2010)

---

Yes you can insert but should be avoided by having a unique constraint or Pkey on identity column.

Since, it doesn't make much sense, if you want to...

Not being a DBA, I don't know the answer to this. Do DBA's work independently or do they get permission first before making changes? AS a developer and "accidental" SQL...

Ah, the decimal point will get you every time. 😉

I missed it in my first read.

"The most commonly used character encoding on the World Wide Web was US-ASCII[9] until December 2007, when it was surpassed by UTF-8.[10][11][12]"

from http://en.wikipedia.org/wiki/ASCII

My gut told me the answer was going...

What, Steve? Have a robot answer the calls or choke the developer? 😛

I do not intend to offend anyone. So, I will not comment on my outsourcing experiences.

I will only say that I agree with Blandry. Many organizations have a culture that...

Steve Jones - Editor (7/23/2010)

---

A few things.

First, as much as...

Thanks Steve. SQL Traps WOULD be a good...

Cliff Jones (7/23/2010)

---

OCTom (7/23/2010)

---

They catch the rodents running around the database. You have your choice of humane live traps, which became available in...

They catch the rodents running around the database. You have your choice of humane live traps, which became available in SQL Server 2008,...

Jusr what we need. Another acronym. 😛

Steve, you mentioned that it can be difficult. What about ROWE can be difficult?

I knew it had to be more than two and thought it was less than 10. So, I stabbed at it with eight and got it right. 😛 It made...

Sometimes simple is all that's required. We DBA and developer folks tend to over-develop. We want to give the suers the world when all they really need is one small...

Duncan Pryde (7/21/2010)

---

Oh wait -...

It's a great question and something that needed research on my part. Thanks for the question.

Has anyone used computed columns and why?

Thanks.