Viewing 15 posts - 1,621 through 1,635 (of 59,066 total)
Indexes are needed as the temp tables are joined to other tables, without indexes the queries would take a lot longer.
You and I have know each other for a...
March 31, 2023 at 8:14 pm
Perhaps a better thing to do is to partition the table?
March 31, 2023 at 7:53 pm
Post deleted... I misread what was being done.
March 31, 2023 at 7:51 pm
Scott's synonym suggestion sounds like your best bet to me.
Strong second here on Scott's synonym suggestion.
March 31, 2023 at 7:47 pm
Thanks, Steve.
March 31, 2023 at 7:44 pm
Just to ask the question, have you checked the datatype for those columns in the base table?
March 31, 2023 at 7:42 pm
Thank you all for the comments. I know my code still needs some tweaking. This was a learning process for me. I have in the meantime tried to get...
March 31, 2023 at 7:37 pm
@jeff Moden, I thank you from my heart for your comment. I greatly respect you and have certainly learned a lot from you. There are no backups because these...
March 31, 2023 at 7:28 pm
I'm curious... why do you think you need any form of looping for this?
SELECT CONCAT('MERGE ',ChannelReadingTableName,' USING ',MainLevelDataTableName)
FROM #DeviceChannelAnd, be aware... I used the table...
March 31, 2023 at 4:26 pm
If you look at the number of reads, there's over 7 billion logical reads. That's more than 56 TERAbytes of I/O.
My first suggestion is to stop the query because it's...
March 31, 2023 at 4:03 pm
For example, an SSRS reports reads from a table the isn't one of the 'core' tables. So I have to research where it is created, find it is created...
March 31, 2023 at 3:47 pm
When it’s written “free ebook to download”, I’m expecting to be free of cost not freely able to download and pay for a ebook…
I was just going to write...
March 31, 2023 at 3:37 pm
Keep in mind, your LOG file(s) may not shrink at first attempt !!!
Even there, they don't mention that you should do a CHECKPOINT first...
March 31, 2023 at 6:18 am
Microsoft say in their index maintenance strategy that if your rebuilding for performance, stop and just do UPDATE STATISTICS instead and see if that solves you problem.
It does now...
March 31, 2023 at 6:16 am
Thank you Jeff,
this did the trick.
I cannot understand why in a table with about 160,000 rows only one value (not field, but value) displayed this issue. It must have...
March 31, 2023 at 6:11 am
Viewing 15 posts - 1,621 through 1,635 (of 59,066 total)