Did you figure out the source of your problem?

It would be interesting to know if the issue is specific to 32 bit SQL Servers only or not. If it is specific to 32bit SQL Servers, then I...

Basically, you are trying to do something that is not allowed for stability reasons in SQL CLR. What exactly are you trying to do? What is the CLR...

I decided to post a blog post to cover this in more depth:

Understanding the VAS Reservation (aka MemToLeave) in SQL Server

It's quite extensive an I hope it helps explain this...

John Sansom (7/6/2009)

---

May I start by mentioning that this is my first attempt at writing an article and that being an experienced and talented author yourself, I am sure you...

I am not really sure where to begin with commenting on this article. It has incorrect information in it, and the code provided for looking at VAS comes from...

One note about your 10% growth setting. This gets to be more expensive the larger the database gets to be. If you have a 500GB database, that would...

It means that you aren't properly managing the size of your database files more or less. Your database files are set to autogrow to prevent the database from running...

Exactly what...

Florian Reischl (6/23/2009)

---

Jonathan Kehayias (6/22/2009)

---

I know that thread and the other article as well, but I don't recall seeing the added information about String.Split() performance on either of them. ...

Florian Reischl (6/22/2009)

---

I...

Sure Adam Machanic wrote a custom string splitter to show the difference between a correctly built Enumerator in SQLCLR over the most commonly misapplied String.Split() function:

http://sqlblog.com/blogs/adam_machanic/archive/2009/04/26/faster-more-scalable-sqlclr-string-splitting.aspx

If you run his tests...

Florian Reischl (6/22/2009)

---

Hi Jonathan

Jonathan Kehayias (6/22/2009)

---

Enabling CLR also doesn't just restrict it to this one assembly. Others can be added as well so unless you have tight control over...

Robert Davis (6/18/2009)

---

I would like to say that the part below is not correct. A tail log backup is not a normal backup. to perform a tail log backup, you...

A good book to get you started would be:

http://www.amazon.com/Pro-SQL-Server-2005-Assemblies/dp/1590595661

However, after 2+ years working with SQLCLR, I'll tell you that appropriate use cases for it are pretty uncommon unless you offload...