No, if the combination of all three columns would always be unique if CHANGENR were added:

dbo.CDPOS ( OBJECTCLAS, OBJECTID, CHANGENR )

You've got the correct clustered index on CDPOS, except perhaps that it's not unique.  If adding CHANGENR to the clus index will make it UNIQUE, you should do that.

Either way,...

If you are putting NOLOCK on an INSERT, UPDATE, or DELETE query, that's not going to do anything. SQL doesn't allow NOLOCK on data change operations as it doesn't...

Surrogate keys are not necessarily bad, if chosen after proper analysis, but just automatically defaulting to using a surrogate...

IF the most critical lookup on the table is the one you've posted, and since you're deleting rows frequently, I'd suggest you consider re-clustering the table to allow clus index...

The ERD is nice, thanks for that.

But I think you need to step back and do the logical design first (designing using Entities and Attributes rather than tables and columns),...

• This reply was modified 1 years, 7 months ago by ScottPletcher.

SELECT SUBSTRING(ID, ID_start_byte_2, 50) AS ID_you_wanted, ID AS original_ID

FROM dbo.table_name tn

CROSS APPLY ( SELECT CASE WHEN LEFT(ID, 1) = 'D' THEN 2 ELSE 1 END AS ID_start_btye_1 ) AS ca1

CROSS...

n/a

You don't actually have to drop both indexes.  You would, for example, often drop one index and modify the other one.

I've started on code to do this process...

For all indexes, or the 1 you tell it to generate (either by index number OR by index name).

As I said, I've been designing code to do my index checking...

You don't actually have to drop both indexes.  You would, for example, often drop one index and modify the other one.

I've started on code to do this process but have...

Actually, partitioning came sometimes accidentally (or coincidentally) help performance.  For example, the data was originally clustered by id, but to partition you cluster it first by a date.  IF you...

Remove the second column from the first IN subquery:

SELECT minutes FROM dbo.timeaccountmovement WHERE ownertype = 1 AND timeaccountid = 8 AND ownerid IN

(

SELECT ownerid FROM dbo.timeaccountmovement WHERE timeaccountid = 73...

Yes, I've used CDC.  I ended up creating my own proc to view change data (basically pre-prepping the params for the MS proc) because the MS proc itself is so...

I see "emp." being referenced, but I don't see "emp" anywhere in the supplied query.

You would have to check each of the joined tables to see if there is an...