quote:

---

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/awarren/worstpracticesnotusingprimarykeysandclusteredindex.asp

---

It's hard...

I"ve used the following, but DAVNovak's idea is pretty cool

SELECT LEFT(Firstname, 1)

+ " " LEFT(Middle, 1)

+ " " Lastname

...

Does anyone here work in a shop that's implementing ADO.NET? I bring this up b/c I'm both DBA and a developer, although I don't get much time to DBA...