Viewing 15 posts - 1 through 15 (of 32 total)
Most likely scenario is probably a script with lots of INSERTs.
January 20, 2024 at 3:47 pm
Probably the most annoying thing on internet today, those annoying cookie-dialogs.
January 10, 2024 at 6:34 am
Yes, but what about fragmentation? Should I bother? FillFactor? It's easier with just one index-column, not multiple (in my head anyway... :))
August 18, 2023 at 12:01 pm
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.
February 21, 2023 at 8:09 pm
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...
February 21, 2023 at 7:10 pm
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...
February 21, 2023 at 3:31 pm
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...
February 21, 2023 at 2:41 pm
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.
February 21, 2023 at 2:16 pm
Instead of changing the clustered index, can you add another index?
Yeah perhaps.
January 20, 2023 at 6:29 pm
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...
January 20, 2023 at 10:46 am
If "Time" were the first in order in the index, that would be much better?
January 20, 2023 at 10:37 am
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),...
January 20, 2023 at 10:28 am
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...
January 20, 2023 at 10:00 am
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...
January 17, 2023 at 8:10 pm
The Id-column is a NEWSEQUENTIALID
March 7, 2022 at 12:25 pm
Viewing 15 posts - 1 through 15 (of 32 total)