Viewing 15 posts - 646 through 660 (of 59,078 total)
You have 15 rows that got expanded to 24 and you say you have 30 million original rows, which would be expanded to 48 million rows according the 24/15 ratio...
March 23, 2024 at 9:08 pm
All,
Thank you for your replies and suggestions. Sorry I haven't been back to this topic, I've had some other unplanned things to sort out. When I get back to...
March 23, 2024 at 8:53 pm
Step 1 would be to stop doing the re-indexing. Chances are that you're actually causing more damage than you're fixing especially if your using REORGANIZE or the old supposed 5/30...
March 23, 2024 at 8:46 pm
I read a wonderful book "A man called Ove" filmed as "A man called Otto" starring Tom Hanks. Read the book. Ove is the GOAT of cranky curmudgeons. The...
March 23, 2024 at 8:32 pm
Yes, I a cranky curmudgeon, and proud of it. I earned it the hard way.
I'm not as old as you are, Rick, but Roger that and ditto that. 😀
March 23, 2024 at 2:14 am
I also download at least the latest version of the "ACE" driver/providers so that I don't need to go anywhere near SSIS just to import a spreadsheet.
https://www.microsoft.com/en-us/download/details.aspx?id=54920&irgwc=1
March 22, 2024 at 2:31 am
See the following for the list of supported Trace Flags.
1118 (No longer required but I used to have it on server wide. I have the equivalent turned on in every...
March 22, 2024 at 2:10 am
Why on Earth would you use PoSh to do this? You have the data in a table already.
https://www.sqlservercentral.com/articles/convert-unix-timestamps-to-date-times-in-sql-server-part1
March 22, 2024 at 1:46 am
Hi Jeff,
At the bottom of the article is a zip file link.
I saw that and I kept asking myself where the heck the link was. I have the "nightlight...
March 21, 2024 at 11:06 pm
From the article:
Further, because we’re aging, we’re not ready to embrace all the wonderful new technologies that are clearly superior in every possible way.
I know I responded...
March 21, 2024 at 10:54 pm
p.s. Read the article at the first link in my signature line below for how to post some readily consumable test data. It'll help you get a coded answer instead...
March 20, 2024 at 6:51 pm
No, I won't be limiting the TicketOpenDate for the query. I may add a month filter to limit TicketOpenDate at a later time. The initial query will look at...
March 20, 2024 at 6:43 pm
Yeah, we do index rebuilds quite often but I am not 100% sure. but definitely that could be one of the reasons.
Jeff, I got your point. Could you please...
March 20, 2024 at 6:39 pm
My two thoughts on things like this continue to be...
March 20, 2024 at 6:16 pm
Thanks for the article, John. I'd like to do an experiment with another method. Can you identify the 3rd party link for where to get the source CSVs from, please?
March 20, 2024 at 6:07 pm
Viewing 15 posts - 646 through 660 (of 59,078 total)