Heheh, I've had those days. 😀 Glad I could help.

SQLSeTTeR (11/8/2012)

---

How do I write multiple IF statements but only one BEGIN block? In other words, I would love to have an OR statement between the IF statements but...

An alternative, which will allow you to more easily see how you're connecting up the different node connections, is as follows.

I've left a note in the code, but the big...

GilaMonster (11/8/2012)

---

Not RID. uniqeifier.

Yes, the cluster plus uniquifier is in the NC index. The uniquifier does not change upon rebuild, hence the NC indexes don't need updating. It did and...

From the same MSDN article:

Rebuilding an index drops the index and creates a new one. In doing this, fragmentation is removed, disk space is reclaimed by compacting the pages using...

Rebuilding a clustered index is basically a drop/create and resets the internal additional RIDs for the index rows on the clustered, forcing all non-clustered indexes to be updated so they...

This particular component is going to take this...

Short form: What you're looking for is to adjust your query with what's called an OUTER JOIN, in this case most likely a LEFT Join.

Basically, your select query should base...

What you're seeing is most likely the primary key, which is both.

The Primary Key is a specific type of index that is also a constraint, and is created as such...

It's annoying but doable. Annoying at the levels of if Jeff has a way to easily attach it via BCP do that.

However, the answer, in shorthand.

First, create a second...

If you take a look in my signature for the link regarding indexes/tuning, we can help you further.

The like is SARGable, no big deal. As is the date. ...

Paul,

In a case like this I would look towards chaining fact tables. I don't know the proper term, I'm not a warehouse expert, I just build 'em.

What it would...

Matt,

What kind of value tests are you looking to do against the rows? As mentioned above, you can do things with lookup tests and the like to test for...

The - symbol usually denotes a negative value, so that's probably right. Hard to tell with the limited information.

What in particular is the concern? You want it to...

Um, errr, hrm.

You do realize we can't see your tables, your usage history, or your heuristics to make that kind of broad recommendation in either direction, correct?

Including columns in an...