Questions tagged [sql-server-2019]

SQL Server 2019 (major build version 15.00.xxxx). Please also tag sql-server.

Filter by
Sorted by
Tagged with
10
votes
3answers
2k views

SQL Server Agent fails after installing SQL Server 2019 CU2

After installing CU2 our SQL server agent randomly stops working. If you go to check on the status of the agent by opening Job Activity Monitor, it comes up blank for a while then throws an error: ...
4
votes
4answers
268 views

Why are [Seemingly] suitable indexes not used on a LEFT JOIN with OR

I have the following [fairly meaningless, just for the purpose of demonstration] query in the StackOverflow database: SELECT * FROM Users u LEFT JOIN Comments c ON u.Id = c....
2
votes
1answer
166 views

SQL Server 2019: InitPersistentVersionStore failed after installing CU2

I have installed SQL Server 2019 CU 2 over a vanilla install of SQL Server 2019 RTM. Now I am puzzled by the following messages in the error log at startup: RecoveryUnit::...
2
votes
5answers
310 views

Granting a user a permission to restore a database

In a database I created a user with the following roles: Server Roles public Database roles db_backupoperator db_ddladmin db_datareader db_datawriter The problem is I don't want to change the ...
1
vote
1answer
54 views

Table size in Azure SQL Managed Instance vs On Premise SQL Server

In doing a test, I have observed that the size of the same table with the same exact DDL (created from scratch) with the same exact data (10M rows) varies drastically in our Azure SQL Managed Instance ...