Indexing SCDs drives me nuts, that's why I was looking at it so carefully- I still haven't seen a good general solution for it, especially if you need to access...

Your PK is defined on InvoiceIDO, not InvoiceID.

ALTER TABLE SCF_Invoices ADD CONSTRAINT PK_SCF_Invoices PRIMARY KEY CLUSTERED

( ValidFrom ASC,

InvoiceIDO ASC

)

In a way, it's all semantics. Whether SCF or SCD really depends on usage, nothing more. In the stuff that I work with, there is no question that invoices are...

Since you don't delete from your Invoice "SCF" table, doesn't the PK give you a violation when you do reloads from the same day?

R. C. van Dijk (8/26/2009)

---

I totally agree. The complex queries I was talking about perform a lot of different actions, complex business logic is implemented in SP's. These kind of...

R. C. van Dijk (8/25/2009)

---

wbrianwhite (8/25/2009)

---

No offense, but I disagree. One large query that gets all your data at once is likely to be significantly faster than separate stored...

It looks like a multikey index will be used ("index seek") if the first key in the index is referenced in the WHERE clause without a function and the second...

hmmm.....On our db, these resulted in scans 100% of the time and removing the functions (isNull Usually) fixed the issue 100% of the time.

I'd have to see specific examples in...

I can't duplicate the effect documented in the article. In earlier versions of SQL Server, it was well know that the definition of a SARG did not include an expression...