Heh... SQL Server 2017... the last and final version that had good speed.  They "Robo-Copped" 2019 and up with all sorts of "rules". 😉

(bumping the page 2 fault on this forum)

I used to be a front-end Developer... that's why I don't rebuild indexes all the time   ... The page splits that came after the rebuilds would slow down...

To be clear, I don't know how obvious or obscure the bug might be. It might be expected behavior to detect duplicate posts, though I'd expect it to say...

Hi Everyone, I have the data in the below form :

Desired output:

Here...

Team,

Please suggest or if you have an example please share the link for loading AML (anti moneylaundering)files into SQL Server. Meaning file having multiple recs in the .txt/.cvs file....

I thought this must be from years ago but only a few months. Maybe just the reply.  I've had the same discussions, or more like yelling matches with DBA...

You can create a 2 part synonym with the same table name as before that points to the linked server using 4 part naming.  Zero code changes will be required.

However,...

Wow.  I have to ask... what makes you think our complaints would be acted upon if...

Thanks, I'll push this a bit and see if someone can track down this error. I'm guessing this is some sort of file error, but would be good to...

Duplicate post removed.

Because I told him to. 😉  It works just fine on MAX datatypes.  It doesn't...

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