Stack Exchange

These posts were previously published on the Stack Exchange Network, and have been cross-posted here for ad-free posterity. I’m no longer active with responding to questions on the Stack Exchange Network, and consider these to be the canonical links for my answers. If I update any of my responses to correspond to changing technology, they will only be updated on my own site, and not on the Stack Exchange post.

Always On Synchronous Commit Mode With Large Delays

October 18, 2020 Andy 0

Question For SQL Server Enterprise’s Always On availability groups in Synchronous Commit mode, is there some amount of latency that can’t be exceeded? For example, can it work between very distant data centers, such as between the US and Europe? asked 2020-10-18 by uncaged Answer … [Read More]

sp_update_schedule says @schedule_id does not exist

October 6, 2020 Andy 0

Question I wrote a script that reads job schedules from msdb.dbo.sysschedules and runs sp_update_schedule to change the active_start_time for a given subset of jobs. In each case, sp_update_schedule fails with the message "The specified @schedule_id(‘xxx’) does not exist". (MessageID 14262, Severity 16) Is the schedule … [Read More]

Remove/suppress dashes from “Results to Text” output in SSMS?

June 15, 2020 Andy 0

Question (This is just a “reproducer”, not the real code, because that’s long and complicated.) The output of is: —————————————————————————– MSSQLSERVER —————————————————————————– Microsoft SQL Server 2014 (SP3-CU4) (KB4500181) – 12.0.6329.1 (X64) Jul 20 2019 21:42:29 Copyright (c) Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on … [Read More]