What MS is not making particuarly clear is that CLR is intended to, in a couple of versions, replace extended stored procs.

Books Online

---

Extended Stored Procedures

Important:

This feature will be...

Use the 2 DMVs sys.dm_exec_requests and sys.dm_exec_sessions to see details of who is running queries against the server. You can join in the function sys.dm_exec_sql_text to get the details of...

Some other process is holding an extended lock on part or all of the table.

You can use the DMV sys.dm_tran_locks to see what locks are held and by what processes.

Locks...

Could you please post the table schema, the current indexes and a couple of sample queries?

It's unlikely to increase performance, unless the new file is on a different physical drive and IO is your bottelneck. It usually isn't

You will probably get better return on your...

Some of them.

With most it's a working relationship only. Some I'm happy to sit with and chat about anything and everything.

Perhaps what you could do is just a simple check. Does the address have an '@' sign in? Does it have at least 1 '.' (though I seem to recall...

Not a solution, a workaround. There's some connection somewhere that's getting forcefully closed by the server when you do that. If it's in your app and you then try to...

Gut feel is that it's the UDF at fault here. It has to run for each row of the update. It's essentially a hidden cursor.

Is there any way you can...

Not asking about the connection string.

If you open a SQL Server query tool, like management studio, and query the open connections to the server, what do you see?

Stick a...

I'm no C# expert I'm afraid. I would guess that the data table keeps the connection open until it's destroyed.

If you use a SQL querying tool (management studio) what connections...

Because both operands are int, you're getting integer division and the result is an int.

To avoid that, cast one of the operands to float or an appropriatly sized numeric. It...

What do you mean by 'its not getting updated or deleted'?

You get an error?

The update waits forever?

The update succeeds but the row isn't changed?

Extended stored procedures are written in C++. They can do anything. If you write one badly (not handle errors, mess up memory access, etc) you can very easily cause the...

Truncate is not the same as shink. Was my explaination not clear?

Truncate just marks space inside the file for reuse. Shrink changes the size of the file.

Truncates occur on checkpoint...