Msg 402, Level 16, State 1, Line 11 The data types text and varchar are incompatible in the greater than operator.

I am getting above error when i am trying...

Duplicate post removed.

select * from dbo.resolutions r where R.documentid = 828222222 and DATALENGTH(r.resolution_text) > 0

resolution_text Text column is taking More time while Querying,

Need to Replace DATALENGTH, when  i replace datalength condition

as ...

Surely if there are fewer junior developers because most of the junior work is being done by AI, there will also be fewer juniors available to become experienced developers....

I'd like to hold...

To date, I'm the least impressed with BING AutoPilot and Claude 3.5 Sonnet.  I'm especially disappointed in Claude 3.5 Sonnet because it doesn't seem to provide references like the others...

Neither of those are an "Actual" execution plan.  They're both "Estimated".  While that's close, it misses certain nuances.  It does appear...

I know  you are after how to estimate X - that is not really a good way to go as there are way to many unknowns, and without looking...

I have nothing good to say about SQL Server 2022.  Any benefits have been outweighed by things like you describe and some seriously slow running code.  MS broke things starting...

This is the query with the plan (names have been changed):

DECLARE @DateColumn  DATE = '2024-07-01';

DELETE s 
FROM [Schema].TableName s 
INNER JOIN #WorkingTable q
ON q.Column1 =...

This won't tell you if a table is "empty" or not but it will tell you if it has been used by users since the last restart or not.  I...

Please post the Actual Execution plan for the DELETE of just ONE row.  Attach the ACTUAL execution plan so we can take a look at it.  A graphic of the...

Before you mess with those things...

... try setting the following...

1. Make sure Compressed backups are enabled (UNLESS your database is encrypted https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/backup-compression-sql-server ).
2. Set the "buffercount" to 17 as a...

Also, put the variable name in a QUOTENAME() function... just to be safe two ways.

@JasonO

Lordy.  My apologies.  I just noticed that the table you posted has no Clustered Index.

I have to assume that you're not rebuilding the HEAP with Ola's Code, correct?

Also, you said...