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...

Pleasure.

I'm still unclear why you're using dynamic SQL at all. There doesn't seem to be a need.

See my edited post.

It is possible to do that as a check constraint, however be aware that email addresses are very complex to validate properly. See here for some details on what is...

You can't change sys.databases. It's a system view.

log_reuse_wait_desc tells you what the log is waiting for to be reused. Nothing more. It's a report of database information, not a...