Interesting idea with a message-lookup but I think I want to make the smallest possible changes at the moment so I think this'll have to do at the moment.

I'm really curious as to the why behind adding a checksum value to the table, based on a column named "Message", while then including the column named "Time", that...

You'll find that logical fragmentation just doesn't matter that much.  Since you lowered the FILL FACTOR as you would for a Random GUID (which the BINARY CHECKSUM resembles in...

• This reply was modified 1 year, 8 months ago by  oRBIT.
• This reply was modified 1 year, 8 months ago by  oRBIT.

I'm aware I'm only able to use EQUAL's here, not words, but it'll do for me. What I did was to implement a persisted computed column:

ALTER TABLE...

I did some experiments with BINARY_CHECKSUM and I think that'll do for me and for my needs, it's good enough and simple to implement.

Yeah perhaps.

I'll be fetching like 50-100 rows only so it's tiny amounts..

I don't have any problems with nonclustered indexes. I was just afraid I might need to include all columns I...

If "Time" were the first in order in the index, that would be much better?

Time is of datatype "datetime".

"Time" is part of the clustered index, but the clustered index, as stated in the first post, consists of total of 4 columns (bigint, int, varchar(255),...

• This reply was modified 1 year, 9 months ago by  oRBIT.
• This reply was modified 1 year, 9 months ago by  oRBIT.

Yeah, there's an index on the id of the table (UNIQUEIDENTIFIER) but I don't think I have any use of that for this query.

I don't think I'm able to share...

I mean within the SQL itself. Assume something like this fictional code:

IF (condition...)

BEGIN

SET EXECUTION_TIMEOUT=1000

SELECT * FROM dbo.VeryLargeTable

-- If the above select-statment takes more than 1000ms it aborts itself and throws...

The Id-column is a NEWSEQUENTIALID

I wonder if there might be some kind of workaround here.. Could I temporary transform the data (quickly obviously) in some way that makes calculations faster?

I doubt some recursive function...

Ok, thanks for the help anyway.

Sounds like some kind of function is needed.. My experience is that functions should be use with care in terms of performance.

Anyway, to be contiunued..

Here it is. I've removed lots of other columns that's not relevant.

CREATE TABLE [dbo].[MyTable] (
    [Id]        ...

• This reply was modified 2 years, 8 months ago by  oRBIT.