I was thinking about this and is the data accurate/valid as it is currently?

What I mean is since you are getting duplicates, that makes me think that a single badgeID...

What is the value of the following:

string strConnection = ConfigurationManager.AppSettings["GroupStatus"];

?

My thoughts are that strConnection is connecting to MASTER or the user specified in the connection string has master as the...

I think first you need to understand the difference between a database snapshot and a backup.  The snapshot just marks a point in time of the current database state and...

The documentation says:

AUTO

This option allows SQL Server Database Engine to select the lock escalation granularity that's appropriate for the table schema.

If the table is partitioned, lock escalation will be allowed...

My first step when doing the statistics time or IO related analysis is to turn off the execution plan.  That is going to skew your information.  I would also recommend...

I think the easiest way is going to be by casting it to VARBINARYA(MAX) and then manually going through.

So something like this:

SELECT CAST('HELLO' AS VARBINARY(MAX))

Which gives you:

0x48454C4C4F

0X...

Was doing a bit of googling on the ACE 12 and 16 drivers and found this article:

https://techcommunity.microsoft.com/t5/sql-server-support/dbf-file-name-is-truncated-to-8-characters/ba-p/1493456

Apparently in some versions of the driver, the file name is truncated to be...

On a slightly different note, I would be hesitant about using the MONEY data type as it is an approximate data type.  NUMERIC is likely going to be a better...

quick google:

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/063bc0c2-5201-4c4f-a4d0-0c20f31c64e2/what-are-the-remote-logins

Linked servers can use remote logins too.

Here is how to add a remote login:

https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-addremotelogin-transact-sql?view=sql-server-ver15

In the end, it REALLY depends on what you want to capture.  What data is interesting to you and will save your bacon in the event something seems wrong.  Can...

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