DBA Stack Exchange Archives - Page 6 of 15 - Andy M Mallon

Cardinality , Parallel Hint alternative for MS-SQL

March 31, 2021 Andy 0

Question This is the oracle query that I have, I want to create similar query for my MS SQL DB, Any help please asked 2021-03-31 by Luv Gupta Answer Just remove the hint for SQL Server. The cardinality and parallel hints are designed to help … [Read More]

Job management: How to get the next running date by querying MSDB

November 27, 2020 Andy 0

Question Table sysjobschedules contains 2 columns next_run_date and next_run_time. With the help of sysschedules and column enable it should be easy to determine the next running date/time of a specific job. However, when you change a schedule, sysjobschedules is only refreshed 20 minutes after alteration … [Read More]

log send queue size and redo queue size in AG

October 19, 2020 Andy 0

Question I am trying to figure out the way to monitor these 2 events log send queue size – I can see this in perfmon Redo queue size – I can see in dmv but not in perfmon counter Is there any way of using … [Read More]

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]

Replication of only updates and inserts

October 14, 2020 Andy 0

Question I have two sql servers, in the first I want to keep the data from the last three months and in the second I want to keep all the data with the purpose of getting historical reports. I know how to do a transactional … [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]

Can we enable tls 1.0 on MSSQL Server 2019 on database level? if yes then how?

September 25, 2020 Andy 0

Question i am running sql server 2019 on Linux box and trying to connect using a Windows server 2016 client, how can we enable TLS 1.0 for SQL Server 2019 on the Database/instance level. TIA. asked 2020-09-25 by Rafay Pervaiz Answer TLDR You don’t. Long … [Read More]

SQL Server 2019 Database stuck In Recovery state after restart

September 23, 2020 Andy 0

Question SQL Server was restarted by mistake, when it came online, database came back in "In Recovery" mode. Check from error it says "Recovery of database ‘DB1’ (5) is 8% complete (approximately 27146 seconds remain). Phase 2 of 3. This is an informational message only. … [Read More]

How to dig deeper into ASYNC_NETWORK_IO waits

August 15, 2020 Andy 0

Question I’ve been handed a graph that comes from SolarWinds showing top wait events broken down by day. The last 2 days there’s a part of the daily color coded bar representing a total of 3 hours for ASYNC_NETWORK_IO. Still trying to see if I … [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]