Senthilnathan.Karunakaran (6/25/2009)
We did performance and scaling test to split the comma separated string value using XML query and SQL function.The plan was better with XML split than SQL function; however XML query performance degraded when number of concurrent users increase. SQL function did better in scalability test.
Cool. Let's see the test code and the data generator.
--Jeff Moden
Change is inevitable... Change for the better is not.