Welcome to Romanian SQL Server User Group Sign in | Join | Help

Browse by Tags

All Tags » SQLCLR   (RSS)

SQLCLR .NET 4-based behavior differences in SQL Server 2012

As I mentioned in a few previous blog entries, SQL Server 2012 runs the .NET 4 version inside of SQL Server. Your SQLCLR code may be affected by some behavior differences between .NET versions 2.0/3.5/3.5 SP1 and .NET 4.0. I like the way SQL Server chose Read More...
Posted 27 noiembrie 2011 14:52 from Bob Beauchemin's Blog | (Comments Off)
Filed under: ,

Per-appdomain diagnostic info in SQL Server 2012 SQLCLR

In SQL Server 2012, SQLCLR now loads .NET 4.0 code rather than .NET 2.0 as in previous versions of SQL Server. Note that the "main system" assemblies (e.g. mscorlib.dll, System.Data.dll) in .NET did not appear as a separate directory, between Read More...
Posted 27 noiembrie 2011 14:45 from Bob Beauchemin's Blog | (Comments Off)
Filed under: ,

A quick set of SQLCLR spatial decomposition functions

Saw a request on the SQL Server spatial forum this morning for routines that would decompose a geography type to a set of Lat/Longs. A while ago, I was experiemnting with spatial decomposition, and happened to cruft up a couple of SQLCLR table-valued Read More...
Posted 10 septembrie 2011 07:35 from Bob Beauchemin's Blog | (Comments Off)

SQLCLR-based libraries available from TotallySQL

I've always been interested in SQLCLR, and wondered about the potential for producing libraries of useful functions for a variety of specialist purposes. With the inclusion of the spatial and hierarchyid data types in SQL Server 2008 as well as a Read More...
Posted 30 august 2011 08:07 from Bob Beauchemin's Blog | (Comments Off)
Filed under:

Denali memory allocator changes and SQLCLR

Once upon a time (well, now, currently), there were two memory allocators in SQL Server, the single-page allocator and the multi-page allocator. The single-page allocator was used for almost everything (data buffers, caches, etc); the multi-page allocator Read More...
Posted 19 august 2011 08:58 from Bob Beauchemin's Blog | (Comments Off)

Hold it right there, you're a user-defined aggregate

I've been trying out the windowing extensions (the OVER clause extensions and friends) with different kinds of functions (aggregate functions, first_value, last_value() etc), and thought I'd use a SQLCLR aggregate. After all, they're just Read More...
Posted 27 iulie 2011 15:43 from Bob Beauchemin's Blog | (Comments Off)

What appears in DMVs for SQLCLR?

A variation of the following question came up in a mail list that I’m on. Can you see currently executing SQLCLR code statements (i.e. the underlying C# code) in any of the sys.dm_exec… DMVs? Or anywhere else? This turned out to be more interesting Read More...
Posted 20 mai 2011 17:53 from Bob Beauchemin's Blog | (Comments Off)
Filed under:

SQLCLR debugging and VS 2010 revisited

In my blog entry from about a month and a half ago, I summarized my finding on using Visual Studio 2010 with SQLCLR, and the partial support of SQL Server 2008 new features. One feature (with the disclaimer that's it's not preferred/supported) Read More...
Posted 21 iunie 2010 12:21 from Bob Beauchemin's Blog | (Comments Off)
Filed under: ,

Visual Studio 2010 and SQLCLR 2008 new features

There's a special kind of project for SQLCLR development in Visual Studio. It's been around since Visual Studio 2005, when SQLCLR was introduced in SQL Server 2005. When SQL Server 2008 was released, there were a bunch of new features introduced Read More...
Posted 2 mai 2010 15:33 from Bob Beauchemin's Blog | (Comments Off)
Filed under: ,

Temporary table lifetime and SQLCLR stored procedures

People are sometimes concerned with the lifetime of temporary tables they create in CLR code. As an example, if I use a parameterized statement in .NET code, the SqlClient provider wraps the statement in exec sp_executesql. If the statement batch includes Read More...
Posted 1 septembrie 2009 08:45 from Bob Beauchemin's Blog | (Comments Off)
Filed under:

On SQL Server and .NET 4.0

I finally got around to install .NET 4.0 CTP today on a SQL Server box to test a long-held theory. Didn't quite work out the way I'd thought. When .NET support was introduced in SQL Server 2005, there was a lot of interest in how SQL Server and Read More...
Posted 1 mai 2009 09:13 from Bob Beauchemin's Blog | (Comments Off)
Filed under: