DBA Stack Exchange

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]

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]

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]

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]

Question I’m working on a web app which is using SQL Server Express (Microsoft SQL Server 2016 (SP1) (KB3182545) – 13.0.4001.0 (X64) Oct 28 2016 18:17:30 Copyright (c) Microsoft Corporation Express Edition (64-bit) on Windows 10 Pro 6.3 (Build 18362: )). The web app is … [Read More]

Question I can take databases offline (via GUI) but can’t bring them back online. The server details are as follow: RDBMS: MS SQL 2016 Express Host: Amazon AWS/RDS Free Tier Details/History of the Problem A few months ago, I created a db instance on Amazon … [Read More]

Question SQL Server System Databases, as far as I know, always have those same IDs and I have seen lots of maintenance scripts on the internet relying on the predicate WHERE database_id > 4 to exclude them from the actions of the script. Also, if … [Read More]

Question We have got a procedure on SQL Server agent jobs and this job started to hang on transaction for many hours with wait stats CXCONSUMER and never complete. The problem is after we noticed that it was hanging we kill the job and started … [Read More]

Question I have a stored proc spGetSites that returns three columns for SiteName, SiteId and UnitCount. The stored proc runs perfectly fine. I’m trying to store the results of the stored proc to a temp table @Site to use for my report with below syntax. … [Read More]

Question I need to let MySQL to check the uniqueness of a VARCHAR column which is 5000 max length and is not the primary key. I can use an index of length 500 on the column to speed up query, but how to create an … [Read More]