Viewing 15 posts - 16 through 30 (of 32 total)
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...
March 4, 2022 at 3:10 pm
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..
February 24, 2022 at 6:58 am
Here it is. I've removed lots of other columns that's not relevant.
CREATE TABLE [dbo].[MyTable] (
[Id] ...
February 22, 2022 at 5:29 am
I've experienced the random GUID-"problem" upclose in other tables. Index is 98-99% fragmented just a few hours after a defragjob has completed. There's frequent INSERT and DELETE in that table.
July 1, 2021 at 7:24 pm
A majority is below 3000 characters, most are alot smaller than that.
That LOB overflow stuff is nothing I've touched before (as far as I know anyway).
July 1, 2021 at 7:11 pm
No, no datacompression here.
Datatypes used are guids, nvarchar(max/XXX), datetime's mostly.
July 1, 2021 at 6:59 pm
It's difficult and exciting at the same time this stuff. 🙂
Staring at a table now, more than 6,000,000 rows, about 25 columns. Posts are not updated that much, but inserted...
July 1, 2021 at 6:47 pm
If I've got a table with 20 million rows, and add an index with (alot) of included columns, wouldn't this take just as much storage as the original table.?
July 1, 2021 at 9:23 am
I've not designed this thing. I am nowhere near an SQL-expert either, but I do think this world is interesting and am trying to learn, that's why I'm in this...
June 30, 2021 at 2:43 pm
I'm trying to learn more about indexes but it's so much stuff to learn. 🙂 But very interesting at the same time.
The reason for my uniqueidentifier non-clustered index is getting...
June 18, 2021 at 8:08 pm
That's interesting hints. Setting the fillfactor here should not prevent, but slow down the current rapid fragmentation I guess?
I'm pretty sure fill factor is configured to "0" for that table...
June 18, 2021 at 7:33 pm
The Id comes from some C# - code I'm afraid.
June 18, 2021 at 7:23 pm
Found another script that didn't reported "duplicate" rows..
June 17, 2021 at 1:55 pm
I'm just trying to force an old (=a few days) queryplan in QueryStore and it looks ok in the UI but when looking in the sys.tables I see this error....
March 23, 2021 at 12:23 pm
I'm "playing around" with a script that feeds Reporting Services that starts another script. It seems (as far as I can see) the last script starts before the first one...
March 9, 2021 at 1:33 pm
Viewing 15 posts - 16 through 30 (of 32 total)