I was reading the Stairway on Indexes. For the tables that I am loading in chunks by year, would I be better off creating a clustered index that has...

Thanks for the recommendations. I will look into those.

By the way, I am a developer. We don't have a dba, so I make do the best I can.

Koen Verbeeck (8/28/2013)

---

Why ADO.NET for a SQL Server Destination? I normally use OLE DB Destination with Fast Load option.

Is the destination database in simple recovery model?

Are the database files correctly...

Thank you all. Much appreciated. I have passed on your recommendations to the powers that be.

Thanks for the feedback.

I've seen the feature comparison, but that wasn't an issue.

Unfortunately, we don't really have the time to do a bunch of testing. The server will be hosting a few databases. A couple of them support an intranet...

Just an update on what I did. I split the query into a base SP and two sub-SPs. Since I had two parameter sets that would never be...

Thanks for the recommendations. I really appreciate them. I will be checking out all of those links.

I tweaked my code to prefilter using the method I said. ...

Thanks for the link. That article was very informative. My query does pretty much fall into his Catch-All classification. This query is being used to populate a...

colA contains division numbers, with values of 10, 20, 30, etc.

colB contains GL Account Numbers with values of 3160, 3180, etc.

colC contains Process Codes with string values like apet, arss...

Just to let you know, I got everything working. I did have to uninstall SSRS and reinstall it. I did have to hunt around for that x86 option....

Thanks for the link, but they don't have drivers for a Progress db. The name is just a coincidence.

I am connecting to a Progress database and running basic SQL commands. According to the VAR that supports our ERP system, there are no 64-bit drivers available for Progress....

Hi,

I did the full install of SQL Server, including SSRS, using the default settings, so I didn't see that option. If I uninstall SSRS and reinstall, should I see...