I've had to solve an interesting problem this week. I started the week with an SSIS package that ran in 2 minutes. It extracts a million transaction records from DB2 to a file, uploads the file to Azure Blob Storage and BULK IMPORT's the file into an Azure SQL Database staging table. All in 2 … Continue reading Quickly Processing One Million Transactions in Azure SQL Database
Month: March 2019
When Loading Data, Should I Drop Indexes or Not?
I just ran a few simple tests in Azure SQL DB to see how each would perform. I have a target table with an identity column that is the clustered primary key, and two other indexes that are the same except for the field order. (Whether having both is useful is a question for another … Continue reading When Loading Data, Should I Drop Indexes or Not?