If you have to compare all columns, just calculate a hash over all those columns and store it alongside in the table. Then you can do your lookup using only...

That does not make it a heap. A heap is a table without a clustered index. Doesn't mean one or...

I don't see why that is relevant?

blasto_max (1/16/2014)

---

I want to change the name because I don't like it. I want to change it...

sneumersky (1/16/2014)

---

When there is more than one "budget scenario" for which you are modeling, it may get a little hairy. This Kimball Design tip suggests the single table approach for...

That question is way too broad to be answered in just a few lines.

I suggest you search for some tutorials on SSIS or grab a good book.

This depends on a whole lot of factors, you're just not giving enough information.

Anyway, an index seek means the index is being used for what is has been build, so...

A csv file is...

Nice question, but a bit ambiguous.

I can start SQL Server Browser with the command net start sqlbrowser.

No switches there 😉

Thanks for the excellent question.

This seems pretty self-explanatory:

Where are you trying to change this? And maybe more important, why?

If you use the dropdown statement you're going to load the entire table with billion of rows into...

How did you configure it? I hope you wrote a SQL statement and didn't use the dropdown menu to select the table.

Do you have permissions on the output folder? Is the path correct?