I would check the source tables (scans and seeks) as the starting point for tuning.  Check the estimates vs actuals at the table level as that is where statistics updates...

When I set up a wildcard cert for my SQL Server 2016 instance, I didn't actually follow that tutorial at all.  My approach was to test it on the test...

Do the Access Database Engine drivers work on Windows Server 2012?

What I am thinking is we know of a bug in the Advantage driver in Windows Server 2019, so lets...

READPAST is what you would use to read only the "unlocked" (ie rows without a lock) on them as you did.

Where your problem MAY reside is in the isolation level...

I don't have an Azure instance, but I just did a test on my SQL 2016 instance and was not able to reproduce what you were seeing.  My test:

            
June 7, 2021 at 5:31 pm
            
#3893064

            
            
                                                
        

Another approach would be the CASE statement, so something like:

CASE WHEN Person.Termination_Date IS NOT NULL THEN 'N' ELSE 'Y' END

I prefer CASE statements over IIF's, but you...

As a thought, are you ALWAYS having that format?  What I mean is an open bracket, a single character, a closing bracking a space, the name, a space a -...

Not a problem.  I imagine there are other solutions as well.  If you KNOW you are wanting NVARCHAR for sure, you could also do a REPLACE on the utf-8 to...

I would start by checking the logs (windows and SSRS) to see what is happening.

Next, I'd load up the browser debugger to see if any errors are showing up in...

If the columns are MOSTLY 'N/A', to me that sounds like a very poor key.  Now, if you are going to overwrite that value with a SEQUENCE or IDENTITY value...

Any luck running SSMS as administrator?

I am just reading the error that the object has no columns (possible, but unlikely as it works on the old system) or the current...

Was doing a little bit of random testing on this and I think the problem is that utf-8 is going to be VARCHAR.  utf-16 would be NVARCHAR.

This is easy to...

I have a thought (may be WAY out to lunch, but just want to suggest it anyway) - what happens if you run SSMS as an administrator and then run...

My guess then is that you may just need to wait for SAP to provide you with a driver that works with SQL Server 2019.

I am guessing that the DBF...

Do you have the same issue if you use the ACE.OLEDB driver or is it a different error?

Or failing that, what about the Visual Fox ODBC driver?  It looks like...

• This reply was modified 4 years, 3 months ago by Mr. Brian Gale.