opc.three (4/11/2013)

---

If you need an unbroken sequence you'll basically be creating a bottleneck on that number being issued such that the getting of the number and the inserting of the...

For reasons I won't go into here, for a system I am developing I can't use IDENTITY so I have a table to hold the next row ID value to...

I have also implemented my own auto-increment (for reasons I won't go into here) that may be totally loony.

I would welcome any feedback/criticism...

I have a table that keeps the...

Besides Mr. RBAR? :-{)

So how many people from SSC.com will be there on Saturday?

Can you look at the existing data in the log table to see what has been inserted in the past?

Thanks for the feedback.

I mainly wanted to make sure it wouldn't anger the SQL Gods (whoever they are) 🙂

One convention used by a previous employer that I found helpful and still use (with some flexibility) is to have a 3-letter prefix on all columns that is an abbreviation...

So is this still the forum software you bought back in 2007?

How has it gone since then regarding the issues presented here?

SQLKnowItAll (5/24/2012)Well... As a database manager you really need to know what the application will be like first to make an educated decision. I'm sure you know that by now...

Lynn Pettis (5/24/2012)

---

Perhaps Service Broker could be used. I would have to do some investigating to be sure, but it sounds like another viable alternative.

---

Instead of a web application, perhaps...

OK. Since this is for HR data which doesn't change very often I am thinking of an on-demand system using a web service.

They would have an application on the...

SQLKnowItAll (5/22/2012)

---

I say develop a web application (if that is allowable by your business rules) that uses 1 database. All required employees will have their own credentials with the proper...

OK. That won't help... 🙁

SQLKnowItAll (5/22/2012)

---

I think in order to give...

I suppose it will depend if you want the locations to be independent of each other. For example, if your web application is in need of maintenance and you need...