Showing related tags and posts across the entire site.
-
[quote user="Tarek Demiati"] I've just tested my on a SQL Server, and recreating the all the records is about 50% faster than performing a MODIFYALL ... Erik, I hope you will be able to notice the same performance improvements ... Let us know [/quote] Well on my side the performance improvement...
-
were you the only person on the server?
-
Perhaps I'm misunderstanding what I was seeing then.... why does the tempdb grow and grow as I insert into my temporary record variable?
-
If you run SQL profiler you will that no temp tables SQL commands will be generated. Temp tables are keep at client side.