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...

That was going to be my guess and for the same reason.

@ 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...

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...

Understood.  For me, performance is 2nd only to a correct result... and its a very, very close second and...

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...

@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...

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...

Here is an alternative that a) does not use an OR and b) does not use a subquery.

WITH TempOrdered AS
(
    SELECT t.ID
 ...

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...

Heh... I saw no indication of your comment being hypothetical.  I'm concerned that others won't, either. 😉

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.

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.

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...

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...