Andy M Mallon - AM²

Databases & Diversity — Checking Integrity

  • Home
  • About Andy
  • Stack Exchange Stuff
    • DBA Stack Exchange
    • Stack Overflow
    • Server Fault
    • Super User
  • GitHub Stuff
    • Profile
    • DBA Database
    • Data Blogger Resource Kit
    • Presentation Content
  • Legal Stuff

Month: February 2023

AG secondary is out of sync for hours after index maintenance

February 21, 2023 Andy 0

Question We have a 3TB OLTP database running Siemens Opcenter MES software at one of our manufacturing plants in China. This is setup in an Always-On Availability group with one secondary node. As this is a manufacturing plant, we are only provided 11 1/2 hours … [Read More]

github logo Github Profile
DBA Database
Data Blogger Resource Kit
Mastodon Logo Mastodon:
[email protected]
DBA.se profile
My Stack Exchange answers (mirror)

Subscribe via Email

Join 979 other subscribers

SSMS Shortcuts

Awards & Programs



Recent Posts

  • Consuming SQL Agent dates & durations
  • Migrating my Stack Overflow answers to blog posts (Sorry for the spam)
  • Not all stats should be auto-updated
  • T-SQL Tuesday: The last ticket I closed
  • Enforce a specific constraint to be checked first?

Archives

Categories

RSS RSS

  • Consuming SQL Agent dates & durations March 7, 2025
  • Migrating my Stack Overflow answers to blog posts (Sorry for the spam) November 11, 2024
  • Not all stats should be auto-updated August 29, 2024
  • T-SQL Tuesday: The last ticket I closed February 13, 2024
  • Enforce a specific constraint to be checked first? October 7, 2023
  • AG secondary is out of sync for hours after index maintenance February 21, 2023
  • Using OPENJSON, can’t get results to GROUP BY December 24, 2022
  • SQL Modulo Function gives the wrong value? November 18, 2022
  • Is SQL Server affected by OpenSSL 3.0 Vulnerabilities: CVE 2022-3786 and CVE 2022-3602 November 8, 2022
  • What’s the use case of disabling an index? September 25, 2022

Copyright © 2025 | Andy Mallon | am2.co