SQL Server 2005: CLR Integration

There are two important memory considerations you may want to track when using SQL CLR functionality: 1) How much memory is SQL CLR using? And 2) How much memory is SQL CLR allowed to use? The answer to the first question is pretty easy to answer...

The required cases for execute permission on UDFs and UDPs are pretty understandable, however the situation for a UDT is not quite so clear-cut. What does “Execute” really mean in the context of a UDT anyway? Simply put, execute permission is required...

Perhaps you’ve heard all about the power and flexibility .NET framework integration provides in Sql Server, read the news articles, seen the example code on blogs, but yet you are still unsure on what benefits it can provide. Some of the best demonstration...