I am pretty sure that you can find the cache stores with the following query:

select distinct name from sys.dm_os_memory_clerks

There are alot of them there, but you can run any...

David Griffiths (7/14/2008)

Surely it cannot be necessary to design all indexes to cover their base tables so that no bookmark lookups take place ? What is that going to do...

It is very unfortunate, but I have been locked in a battle with the Microsoft...

David,

Your execution plan shows why you are deadlocking:

1451 | |--Bookmark Lookup(BOOKMARK:([Bmk1000]), OBJECT:([Taxi1].[dbo].[CompletedJob] AS [CJ]))665Bookmark LookupBookmark LookupBOOKMARK:([Bmk1000]), OBJECT:([Taxi1].[dbo].[CompletedJob] AS [CJ])[CJ].[Status], [CJ].[JobID], [CJ].[NeedsVerification]70.5142140.218748267.7565637E-51182.0717533[CJ].[Status],...

3000 records is quite small actually. Have you taken a stab at this already, and do you have any code that you can show that you are having a...

I have had to do hosts file hacks at times where the VPN wasn't provide DNS resolution properly to be able to connect to a remote server once the VPN...

CLR is already getting more interest, but from experience answering questions, most of it is misplaced. If you can do it in TSQL, you shouldn't use CLR. There...

I know this is an old post, but I can see it was never replied to. That book is full of syntax errors, and typos. I know because...

Having a static member variable isn't going to allow you to ever guarantee results. This is because until the appdomain unloads, your variable contains the last values set to...

Set your output to be SqlString:

[Microsoft.SqlServer.Server.SqlFunction]

public static SqlString InvokeTestService(SqlString strTestData)

{

return...

I am not a VB.NET guru, I do everything in C#, so I had to run this through a converter, but the following should do what you want while maintaining...

This isn't something I would use CLR for. I am curious why you want to do this in CLR like this. A few things that I see is...

This kind of goes back to the questions about happy hour and coworkers. I have seen the bad effects caused by getting to close to coworkers, so I personally...

I started out in IT on a internet helpdesk of a failing local ISP. Money was always short, so the various bills of the company were always behind. ...

You can do it with XML Serialization, but this is likely not the correct implementation following best practices or performance. If you can describe your problem better, we can...