Yes and yes. It's a simple plan and there;'s no reason for it not to be cached and reused....

paul holroyd (12/24/2007)

---

Thanks for your reply

I am using a CLR instead of T-SQL in order to evaluate new features available with sql server 2005. CLR's appear to enable all code...

I'd prefer to rewrite the procedure so that it can handle a set-based solution. Since the proc's only ever called from the trigger, that shouldn't be hard, if the OP...

OK, then it's most likely because the server's collation differs from the databases, or the database has tables in it with different collations.

Check the collation of the DB that...

As far as I know, if the SQL Server is on a domain, the domain's password policy is the one that's enforced. If the server's not on a domain, then...

Did you copy the database from the other server, or just the proc?

The server's default colation only affects the system databases and new databases created on that server. Databases copied...

Is the collation of the 2 servers different?

It looks like one is case sensitive and one is case insensitive. Is that deliberate, or should both servers be the same?

In addition, corelated subqueries in the select caluse can result in poor performance as, depending on the plan chosen, SQL may have to execute each subquery once per row of...

I'm quite fond of the Inside SQL Server 2005 series from Solid quality Learning. They're not beginners books though.

I can't see anything obviously wrong with the code, but then I'm not a C# expert, so I may have missed something.

What I'm curious about is why you're using a...

And to you and your family

Ok, so given what I said above, if, using the example I wrote, you had to find a person with a specific phone number, how would you like the phone...

It is a Saturday. Normal people don't frequent work-related boards over a weekend

I watched Stardust a couple weeks back. Brilliant movie. I must get the DVD. Haven't watched any of the Borne movies, but I do intend to.

At the moment I'm reading...

Very important. Queries can only seek on an index if the columns that are in the filter are a left-based subset of the index.

Look at it this way. If you...