FYI I just changed the script that populates the 3 price table a little bit that way it generates entries that are a little bit more realistic...

Thanks for your reply,...

mmm... How to change the compatibility options that JET uses?

about deleting empty empty rows/cells -> I don't even have to delete anything, i just open the file and re-save it from Excel, automatically the file size goes down.

compatibility...

actually I was wondering... based on your experience which method performs best for cases where you have to extract thousands of rows (tens of thousands in some instances) on a...

thanks! very useful answer

FINALLY! 🙂

I just wasted tons of time on this problem... but I see what my mistake was...

I also had a problem where when exporting to Excel all my data types...

did you mean

SQL Server 2000, released...

got some comments on this on dbforums

http://www.dbforums.com/showthread.php?p=6333362#post6333362

Thanks all, plenty food for thoughts in there 🙂 Thanks for the effort, especially those who put together test case and such.

Let's assume only 3 types out of let's say...

BAM! Jeff has spoken

gotta say although it's not the most popular answer your arguments are strong

thanks for the input, I will meditate on that for a while and see what...

hey all, sorry to bring this post back up again,

I was wondering, perhaps a scenario #4 would be to define insert/update triggers on the details table that will...

this whitepaper I found is quite useful:

http://www.sqlskills.com/resources/Whitepapers/Partitioning%20in%20SQL%20Server%202005%20Beta%20II.htm#_Toc79339956

you will need to setup a linked server between all these different sql server instances otherwise server a won't see the tables on server B

but linked server queries perform horribly......

did you mean Red Gate?

thanks,

and sorry for the row-by-agonizing-row from the other tests 🙂