Not aimed at the author but aimed at the whole concept...  Let's look at the first example prompt in the article...

You are an SQL Server database developer. Assume...

You have some values in the varchar columns provPhoneMain or provPhoneFax that cannot be cast as bigint.

You could try using TRY_CAST which will return NULL if it cannot be converted:

You cannot directly edit files in an S3 bucket.

To edit them you would have to download the file edit it locally then upload the edited file to an S3 bucket.

Since you are using SQL Server 2019 you can use STRING_AGG

SELECT DISTINCT 
       pr2.col1,
       ISNULL(STRING_AGG(CASE...

SQL Server will use available memory to cache data. So if you allocate more memory to SQL Server it will probably use it. But that doesn't necessarily mean you need...

Msg 229, Level 14, State 5, Line 5 The SELECT permission was denied on the object 'fnRule_JobNumber_Validation_multiple_jobcodes', database 'TSE_Automation', schema 'WDM_TSE'.

I have taken the contents of the function and...

For a quick view I would just right click on the database and select Reports\Standard Reports\Disk Usage By Top Tables and look at the report.

Or you could write a query:

The company I work for has implemented ChatGPT 4 on its internal servers, actively promoting its usage among all employees. Given its deployment on company servers, there...

My employer blocks all AI, so we can't use it for anything.

On my own, at home, I've used both Bing Chat and ChatGPT to solve programming problems. Especially for...

duplicate

• This reply was modified 1 year, 8 months ago by Jonathan AC Roberts.

I would initially try creating the temporary tables (#potential_dups and #person_list) before you insert into it and create the CLUSTERED indexes inx_potential_dups_temp1 and index idx_person_1 instead of NONCLUSTERED, and create...

Thanks Jonathon.

Thanks Brian - yeah that table gets massive inserts and updates so I guess indexed view is a bad option.

Tried using exists - same run time:

            
January 4, 2024 at 7:54 pm
            
#4356873

            
            
                                                
        

To resolve this issue, you need to ensure that the ANSI_NULLS option is set to ON for the table 'eligibility'. You can modify the table definition to set the ANSI_NULLS...

• This reply was modified 1 year, 8 months ago by Jonathan AC Roberts.

I would just shrink the data files and rebuild the indexes including the clustered indexes.

If you want to make the query you've given as fast as possible to return the rows you could use a schema bound view:

-- Create the view...