posts - 114, comments - 204, trackbacks - 82

My Links

News

View Anthony Trudeau's profile on LinkedIn

Add to Technorati Favorites

Article Categories

Archives

Post Categories

Image Galleries

Other Links

User Defined Aggregates (UDA) in SQL Server 2005

I finally got back to reading some of my “Introducing Microsoft SQL Server 2005 For Developers” book and I stumbled upon the topic of user defined aggregates (UDA).  I think this is an interesting subject, although probably only useful in very distinct scenarios.

The book talks about using it to concatenate a list of strings (e.g. e-mail addresses).  While this works after some modification of the code in the book (due to beta differences) it really isn't perfect for this situation, because the maximum size of the serialized UDA is 8000 bytes.  (I'm not sure why this value was chosen as the maximum size.)

The following article provides information on creating the UDAs:  http://geekswithblogs.net/tonyt/articles/70274.aspx.

  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati

Print | posted on Wednesday, January 18, 2006 3:50 PM | Filed Under [ .NET SQL Server ]

Feedback

No comments posted yet.
Post A Comment
Title:
Name:
Email:
Website:
Comment:
Verification:
 
 

Powered by: