SQLCLR String Splitting Part 2: Even Faster, Even More Scalable

Articles

Current Articles | Categories | Search | Syndication

By Site Administrator @ Friday, May 01, 2009 8:56 AM :: 338 Views :: 0 Comments

SQL Server MVP Adam Machanic shows a new way of parsing strings in SQL Server using SQLCLR that outperforms all conventional TSQL methods, as well as the most common SQLCLR implemenations, using a custom split function that allows streaming of the results.

Posted @ Friday, May 01, 2009 8:56 AM by Site Administrator

Comments

Currently, there are no comments. Be the first to post one!
You must be logged in to post a comment. You can login here

Survey

Which of the following CLR objects are you currently using in SQL Server?
User-Defined Functions
User-Defined Types
Stored Procedures
Triggers

Submit Survey View Results

Links

Database Administrator’s Guide to SQL Server Database Engine .NET CLR Environment

CLR Integration Team Blog

MSDN SQL Server CLR Forum

Article Categories

Copyright 2007 by SQLCLR.net Terms Of Use Privacy Statement
Website graphics provided by Matt Green Designs
Page generated in 0.0780025 seconds.

All information and example code on this site is provided 'as-is', without any express or implied warranty. In no event will the authors be held liable for any damages arising from its use.

This site is in no way affiliated with Microsoft. Unless specifically stated otherwise, nothing should be construed to represent the official positions or opinions of Microsoft and/or its Employees.