Viewing 15 posts - 46,246 through 46,260 (of 49,571 total)
What MS is not making particuarly clear is that CLR is intended to, in a couple of versions, replace extended stored procs.
Books Online
Important:
This feature will be...
June 13, 2008 at 12:38 am
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...
June 13, 2008 at 12:25 am
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...
June 13, 2008 at 12:23 am
Could you please post the table schema, the current indexes and a couple of sample queries?
June 13, 2008 at 12:21 am
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...
June 13, 2008 at 12:20 am
Some of them.
With most it's a working relationship only. Some I'm happy to sit with and chat about anything and everything.
June 12, 2008 at 8:04 am
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...
June 12, 2008 at 7:39 am
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...
June 12, 2008 at 7:38 am
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...
June 12, 2008 at 6:38 am
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...
June 12, 2008 at 6:24 am
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...
June 12, 2008 at 6:12 am
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...
June 12, 2008 at 5:46 am
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?
June 12, 2008 at 4:46 am
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...
June 12, 2008 at 4:43 am
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...
June 12, 2008 at 4:32 am
Viewing 15 posts - 46,246 through 46,260 (of 49,571 total)