This appears to be functionally equilavent to how identity based identifiers work, only what you're doing is a lot more complicated and requires coding in every stored procedure that inserts....

Oracle, eat your heart out!

All you resellers on eBay can eat your little hearts out too. Ha!

http://www.bing.com/search?q=site%3Aebay.com+%22sql+server+2014%22+%22developer+edition

I'm not understanding the following. Is [GDML.eResults.UserStore] a database with an odd 3 part name containing periods, or is this a reference to a remotely linked database/table?

[GDML.eResults.UserStore].[dbo].[vw_aspnet_UserProfiles]

There are many naming conventions that prescribe things like case, underscores, plural vs. singular, or hungarian notation, but here are some more general guidelines that should apply regardless.

A column should...

Michael L John (4/7/2016)

---

DavidL (4/7/2016)

---

Eric M Russell (4/7/2016)

---

.. The tables in a JD Edwards system were coded with a short alpha sequence and then a 4 or 5 digit number....

Ha!...

By default, a new login has access no databases, and once granted access, they cannot select from anything.

To maximize security, I'd suggest first creating a view that joins the required...

We have open positions for SQL Server DBAs and Database Developers (v2008 - v2016), if anyone is interested in the North Atlanta area, specially Kennesaw/Marietta. Good job market, affordable housing,...

By default, a SQL Server processes will not timeout, unless it is in deadlocked state (an unresolvable locking contention) with another process. In a worst case scenario, a poorly constucted...

🙂

Iwas Bornready (4/5/2016)

---

You just do the job to keep food on the table and a roof over your head. If you are abused get another job. If you can't then...

Rod at work (4/5/2016)

---

Eric M Russell (4/5/2016)

---

Rod at work (4/5/2016)

---

I got caught up reading people's replies to this thread, when I realized that this thread indirectly points out something...

If you have a new project in development and plan to leverage some of the newer features like Clustered ColumnStore or InMemory tables, then definately go for v2016.

However, if...

Rod at work (4/5/2016)

---

I got caught up reading people's replies to this thread, when I realized that this thread indirectly points out something I feel most of us haven't...

.. I was advised by the Sixbit dev's that I should move the listing pictures out of the dB and into their own folder on the C: drive of the...