My version is 11.0.5623 (SQL2012 SP2 CU7), so it looks like I have that hotfix already, which might be is why I'm not seeing any performance issues at this time,...

I dispensed with the complication of trying to move database files without suspending data movement in the AG.

My final process for moving data and log files for databases in an...

I'm beginning to think this has nothing to do with SCHEMABINDING. Perhaps a schema lock on the PFS? Still, I've never had deadlocks like this show up from dropping...

It looks like this is, in fact, the case; Backing up the transaction log on the read-only secondary replica truncates the transaction log on the primary.

What about transaction logs on the primary replica? Will these will need to be manually truncated or will backing up a transaction log on a ROSR truncate the log...

Hi Frederic.

I do indeed have a solution! It ended up on a parallel thread. That dogged me for a long time. Hope this helps.

-Dave

------

Looks like I've got...

Looks like I've got a solution!

If you are experiencing problems with a SEQUENCE resetting to a lower value, disable CYCLING. When I did this, I was able to leave...

Thanks for the info on the foreign keys.

Aside from the automatic clustered index, any thing special about an actual Primary Key Constraint versus a Unique Constraint?

Thanks Dwightrau. Unfortunately I'm not in a position to redeploy. 🙁 Interesting that this fixed it for you. You actually dropped the dB and rebuilt it from scratch...

I believe the $900 includes a coupon for a 15% discount off the exam.

After seeing no problems with NOCACHE, I bumped the cache up to 10. The problem returned and I noticed that the value the sequence is "resetting" to the value...

I continued to have this problem for several days, the SEQUENCE somehow "resetting" to a lower value.

I was caching the SEQUENCE at 50 (as seen above). I set the SEQUENCE...

There are no triggers on the table.

The table has records periodically imported into it, every 5 minutes. Records were created as follows:

integrationQueueID, Created

7002 - 7018, 11:20am

7019 -7023, ...

I continued to have this problem, the SEQUENCE somehow "resetting" to a lower value.

I was caching the SEQUENCE at 50 (as seen above). I set the SEQUENCE to NOCACHE...

Hi Lowell,

No triggers on the table.

The table has records periodically imported into it, every 5 minutes. Records were created as follows:

integrationQueueID, Created

7002 - 7018, 11:20am

7019 -7023, 11:25am

7024 -...