Replacing multiple spaces with a single space is an old problem. The the following link to the post in the discussion where Paul White demonstrates that not-so-little nuance:īe you Neophyte or 'Ninja', thanks for being a part of this community, folks. One of the things that came out of the discussion is the fact that the default collation can make a huge impact on performance. All in all, the discussion makes for an incredible learning experience which is typical of the amazing community of professional people we've all grown to know and love here at SSC. Some folks even took the time to create and post some CLRs to solve the same problem. The discussion that followed this article is also fascinating and a large number of people took part in some rather wonderful testing. If you prefer to 'cut to the chase', that method can be found in a post in the discussion for this article at the following URL: Although this article is still an interesting read (I left everything after the 'Introduction' heading as it originally was), I no longer recommend the method in this article because it has been soundly beaten (more than 6 times faster) for performance by another T-SQL method as demonstrated by Michael Meierruth. As with anything else, improvements can be made to code and the subject of this article is no exception. This article was originally published on November 16th, 2009.

Acfun 表情包下载