Still 8kB data limit for Userdefined Aggreations?

In SQL Server 2005 there ware a 8kB data limit for both user defined data types and aggreations. According tohttp://download.microsoft.com/download/a/c/d/acd8e043-d69b-4f09-bc9e-4168b65aaa71/SQL2008_ProductOverview.doc this limit has been removed for user defined data types, but I wonder if it has been removed for user defined aggregates as well. Does anyone know?

[610 byte] By [OleKristianBangaas] at [2008-1-9]

«« Toolbox Icons Lost
»» Passing Variables from URL and DDL combined

# 1

There is a very strong possibility this limitation will be removed in Katmai.

AdamProut at 2007-10-3 >

top of Msdn Tech,SQL Server Katmai,.NET Framework inside SQL Server Katmai...

# 2

What about the limitation of UDA can only take one input parameter? Is it possible to take more than 1 now?

BTW, is Katmai designed to work with VS Orcas or VS 2005 or both?

Best regards,

dong

xied75 at 2007-10-3 >

# 3

Hey, you're stealing my feature request from connect.microsoft.com

SQL Server 2005 is still using .NET 2.0, so it's for VS2005. I have not tested Orcas myself, but as far as I can remember VS2005 cannot make .NET 1.1 assemblies, and thus I would guess that Orcas won't be able to create .NET 2.0 assemblies either.

OleKristianBangaas at 2007-10-3 >

# 4

Using Orcas with SQL Server (Katmai or SQL 2005) is not a problem. Orcas is still using v2 of the system assemblies (mscorlib and friends), so SQL won't have any issues with that.

The only problem you'll run into using Orcas is if you are trying to create a SQL CLR project in Orcas (automatic deployment and all that ***); that won't work as the project type is checking the version of SQL Server and fails as it is not SQL 2005.

However, you can create normal dll's and deploy them manually (or use my project type, I need to do a proper installer for it though).

So, Orcas works just fine (both for Katmai as well as SQL 2005).

Niels

nielsb at 2007-10-3 >

# 5

There is a very strong possibility that multi-input aggregates will be supported in Katmai.

AdamProut at 2007-10-3 >

# 6

Niels is absolutely right. Note that the CLR in Orcas is a service pack as well as all the supported framework assemblies. If you install SQL Server 'Katmai' and then Orcas on top of it, everything should work just fine.

Thanks,

-Vineet.

VineetRao-Microsoft at 2007-10-3 >

# 7

Ole Kristian Bangaas wrote:

In SQL Server 2005 there ware a 8kB data limit for both user defined data types and aggreations. According to http://download.microsoft.com/download/a/c/d/acd8e043-d69b-4f09-bc9e-4168b65aaa71/SQL2008_ProductOverview.doc this limit has been removed for user defined data types, but I wonder if it has been removed for user defined aggregates as well. Does anyone know?