Dupe Post - Not sure why...

I don't create an indexes on my staging table, should I? Once I implement a merge flag, then it would make sense to add an index for that one,...

Hey Jeff, as always thanks for your advice.

Sounds like I need to create a new table with the right schema and move all the existing data into it as trying...

While trying to learn more about SQL optimization I discovered that SQL can actually show you the execution plan - That's so cool 🙂 So, let's talk real numbers...

I finally had some time to rework my import queries. I changed my SP to use temp tables so now I can run multiple imports at the same time...

There are 18 columns. The 8 indexs corespond to a potential WHERE clause. I seem to recal reading that any column that could be used in a WHERE...

There are 18 columns. The 8 indexs corespond to a potential WHERE clause. I seem to recal reading that any column that could be used in a WHERE...

1) Both I/O and Processor affinity are automatically so all 4 cores are (disabled, but) checked

2) No, I hadn't considered data cleansing in bluk, but if that's the way to...

There are 2 types of logs with slightly different schemas. Depending on the log type, it goes into 1 of 2 staging tables and then both end up getting...