No, the clustered index is only on one column: the PK. The PK is an integer.
I have one clustered index per table (on the PK) and non-clustered indexes on every FK. Although I must admit I do not really understand the...
Good point. I tried removed the constraints and checked the operation again, but it did not perform significantly better. There are no other delete...
I recompiled the table, but that did not make a difference. I don't understand how these views can help me to find the operation that takes so...
First of all, thanks for your answer. In this case the trigger actually does nothing. I deleted all lines of code except one "SET NOCOUNT ON", and...
Any ideas ?
I currently have a problem with the performance of a delete operation: The operation deletes about a dozend rows from a table "VERSIONS" with the...
We use C++ OLEDB consumer templates: For example: CCommand <CNoAccessor, CNoRowset> cmd; HRESULT hRes = cmd.Open( session, _T("UPDATE DATA SET...
Thanks for the hint. I tried this, but unfortunately it did not make any difference, even in batch commands[*-)].
Since the connection is a dedicated link for our company, the bandwith is quite stable. The number of rows is 1. I'm just trying to improve...
Since it is a test database and I am the only one using it, I don't think that there is any blocking and simple SELECT commands aren't any faster....
Is there a way to improve performance for a simple SQL command (e.g. UPDATE DATA or INSERT statement) over WAN. I am accessing a SQL server database...
Separate names with a comma.
