Archive for

TSQL – data loads using the 610 flag

I have been loading large volumes of data into SQL Server. The requirement was to load an initially empty table, then repeatedly load large volumes of data (over 1 million rows a time) into the already populated table. I tested two approaches. First, I dropped the existing clustered index, populated the table and re-built the index. … Continue reading →