Viewing 15 posts - 1,246 through 1,260 (of 59,065 total)
Good morning,
I am able to rebuild this index. And thats the problem, when I could rebuild the index, why wouldn't the Ola script rebuild the index?
I thinks, this is...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 1, 2023 at 6:44 pm
November 13, 2025
That was going to be my guess and for the same reason.
--Jeff Moden
Change is inevitable... Change for the better is not.
July 31, 2023 at 6:31 pm
@ Andreas,
How are you verifying the fragmentation on that table after you've executed the OLA script?
Also, Michael's question is valid... your answer might be "to defragment the bloody index!" but...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 31, 2023 at 6:28 pm
I don't see where anyone has already said it, so I'll say it… “MMYYYY” is a date format to avoid. Using “YYYYMM” instead will allow you to actually sort...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 30, 2023 at 8:19 pm
If performance is a requirement then yes it could be refactored
Understood. For me, performance is 2nd only to a correct result... and its a very, very close second and...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 30, 2023 at 6:11 pm
Everyone says that PowerShell is an essential skill for the modern DBA... bumping this for Bruin to give people the opportunity to demonstrate that skill. 😀
ZZartin did make a submission...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 27, 2023 at 3:13 pm
@steve-2 Collins,
I'm still interested in the ChatGPT prompt that you used to generate the populated test table because it'll help people understand how to use ChatGPT to do such a...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 27, 2023 at 3:09 pm
For anyone that wants to do a little analysis as to why the use of OR is so bad and to do a little performance testing, here's code to build...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 27, 2023 at 3:05 pm
Here is an alternative that a) does not use an OR and b) does not use a subquery.
WITH TempOrdered AS
(
SELECT t.ID
...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 27, 2023 at 3:00 pm
Hi Ddee,
You can achieve the desired result using the following SQL query:
sql
SELECT ID, flag, name FROM your_table t WHERE (flag = 0 AND NOT EXISTS (SELECT 1 FROM your_table...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 27, 2023 at 2:53 pm
Heh... I saw no indication of your comment being hypothetical. I'm concerned that others won't, either. 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
July 27, 2023 at 6:32 am
My personal feeling is that phone numbers for people that have taken a survey are actually no one's business and should not be included in a DW.
--Jeff Moden
Change is inevitable... Change for the better is not.
July 26, 2023 at 5:41 pm
Hi, Ellen. Welcome aboard.
It'll be interesting to see how the ORs in that affect performance on larger tables. I'll try to setup a larger test tonight.
--Jeff Moden
Change is inevitable... Change for the better is not.
July 26, 2023 at 5:24 pm
Preamble:
I know Jonathan posted test code and solution code but his code returns the word "Header" for the "Edge Case" of the "LineType" (my name for the "field") not being...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 26, 2023 at 2:39 am
We are in the process of rolling out SQL Server 2022 to production. Hopefully getting the first environment done after the Summer. The dealbreaker for us was Azure AD...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 25, 2023 at 5:25 pm
Viewing 15 posts - 1,246 through 1,260 (of 59,065 total)