Eugene Elutin (9/19/2012)

---

ScottPletcher (9/19/2012)

---

Eugene Elutin (9/19/2012)

---

...

ISO currency and Country codes are a prime example of an when the natural key (ISO Code) can be used as an Identity column and...

If you need to maintain backwards compatibility with versions of SQL Server prior to 2008, then don't use Merge. Otherwise, it does have advantages.

The main advantage, from my perspective,...

CELKO (9/18/2012)

---

And now you've got a salesperson and his manager on the phone to you. They need to insure an expensive (high premiums, low-risk) collectible car, which doesn't...

When I was job hunting 2 years ago, I made sure to get the salary range before I bothered with even a first interview. They know what they're getting...

Does the report require the user to have Windows authentication, or does it run under the SSRS account? If the user-account, then what you're probably running into is what's...

Lowell (9/18/2012)

---

i just tripped over this exact lack of planning by the database architect when switching from one insurance agency to another. From Geico to Progressive: I saved 30% or...

Eugene Elutin (9/17/2012)

---

GSquared (9/17/2012)

---

Eugene Elutin (9/17/2012)

---

And you didn't respond to the basic assertion about e-mail, which is its horrible weakness as a primary key for human beings. I...

Think of a parking garage (disk) and parking slot numbers (identity,...

David.Poole (9/18/2012)

---

I think NoSQL is a new name for a much older concept.

In fact I...

I'd dump the cursor, put set-based code in the trigger, and call it a day.

Or, better yet, use a proc for all updates/inserts into the table, and have the proc...

Are you trying to exclude "_1_" and "_2_" in the same filename?

SET NOCOUNT ON;

IF OBJECT_ID(N'tempdb..#FILE_PROCESS_LOG') IS NOT NULL

DROP TABLE #FILE_PROCESS_LOG;

CREATE TABLE #FILE_PROCESS_LOG ([FILENAME] VARCHAR(25));

INSERT ...

ScottPletcher (9/17/2012)

---

GSquared (9/17/2012)

---

ScottPletcher (9/14/2012)

---

Code below has fewer calcs and does not depend on any SQL date settings.

DECLARE @year int

SET @year = 2012 --<<-- chg as needed

SELECT

...

Eugene Elutin (9/17/2012)

---

And you didn't respond to the basic assertion about e-mail, which is its horrible weakness as a primary key for human beings. I still maintain that...

CELKO (9/17/2012)

---

Both concepts also assume that all data will be for current-era entities. DUNS numbers only go back to 1963. E-mail for common use, even in tech-heavy...

GPO (9/16/2012)

---

Just because the relational model has a very good track record, doesn't mean we shouldn't be careful what we take for granted. For example, if someone had told me...