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

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