I think I was misunderstanding how temp tables worked in SQL Server (specifically global vs local scope). It seems light may be dawning on Marblehead over here. I...

"When you create a clustered index on a naturally incrementing field, all inserts happen on the last page, until it's full, then it splits, and the same thing happens over...

Current Access data files can run 150-200 MB and certain reports could consume up to about 40% of that data (standard for largest reports would be more like 20-25%). ...