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 10 months, 4 weeks 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 10 months, 4 weeks 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...

Indexes on [dbo].[eligibility]([member_id]) INCLUDE ([eligibility_id])

and [memberphonelookup]([member_id])

Is it really returning all the rows in the table? If so then why has the OP got a where clause?

How many rows does the query return?

An obvious solution is to create an index on Final_date and include columns (column1, column2... column18)

You might be able to get away with just...

I expected that if I use pagination it will only load 1st page for me, which should be very quick. And load the rest pages only if users request...

Instead of applying the recompile at the procedure level, you can apply it at the query level within the stored procedure using the OPTION (RECOMPILE) hint. This way, only specific...