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
0
votes
2answers
46 views

Database was shutdown due to error 9001 in routine 'XdesRMFull::CommitInternal'

I have encountered this situation on one of our production server. The database came backup and DBCC Check reported no errors. Also, there were no other errors logged in Event Viewer. I know I am ...
1
vote
1answer
26 views

Why am I seeing poor performance on SQL server 2019 and asynchronous AlwaysOn

I have recently migrated a 2008 sql dB that’s about 170 GB to 2019 with asynchronous always on. The application that uses this dB hits it pretty hard and I’m seeing an increase of about 2 ms on every ...
4
votes
1answer
179 views

Why is my SQL Server giving out of memory errors when there should be plenty?

I have a production system running SQL Server 2019 Standard edition. It recently had a problem 3 times in 1 day where it became unresponsive until a reboot. Errors seem to point to memory limitations. ...
0
votes
1answer
33 views

How to troubleshoot “Encryption not supported on the client OLE DB provider ”SQLNCLI11“ for linked server” error

We are using LocalDb for integration/unit testing of a .NET Core application. I have been using this solution for months and recently started getting sporadic errors. It seems to happen the first time ...
0
votes
2answers
49 views

DNN Listener resolving to a secondary server in WSFC & AO AG

I have an Azure AO AG which consists of three servers (all WS-2019 & SQL-2019 CU8): A - Subnet 1 - Principal Server (Sync) B - Subnet 1 - Secondary Server (Sync) C - Subnet 2 - Secondary Server (...
1
vote
0answers
55 views

Preventing three SQL Left Joins from creating duplicate rows

I have 4 tables [tA] is the main data point. A customer could have more than one ID Code, or the same ID Code which has been renewed, and ID Codes can be transferred between customers, but a customer ...
1
vote
1answer
37 views

Will SQL Server check FK restrictions between row deletes in a single DELETE statement?

I have a table that is self-referencing: CREATE TABLE [dbo].[TestTable] ( [id] [bigint] IDENTITY(100000,1) NOT NULL, [referenced_id] [bigint] NULL, CONSTRAINT [PK_TestTable] PRIMARY KEY ...
-4
votes
2answers
69 views

Sort operation taking most of the query cost [closed]

Please see below query and execution plan - Any advice on how to get rid of SORT operator cost (nothing coming on missing indexes recommendation)
0
votes
1answer
27 views

SQL Server 2019: Rasing errors between 1 and 13000

I've been struggling with a task which requires me to raise a number of errors for testing purposes. Of course the time consuming errors are between 1 and 13000. I've managed to do them, but I need to ...
0
votes
1answer
32 views

seeding mode in SQL Server 2019

Does activating the TF9567 seeding mode trace flag speed up the synchronization process in AlwaysOn? I am using SQL Server 2019.
0
votes
0answers
13 views

Master data services(MDS) upgrade from SQL2016 to SQL2019

Team, I have not worked on MDS before and need some advice/inputs. We are doing an doing an in-place upgrade of MDS (master data services) from SQL2016 enterprise to SQL2019 enterprise. i would like ...
0
votes
0answers
25 views

SQL Analysis Services Microsoft ACE OLEDB provider is not displayed

I working on an SQL Analysis Services school project and my given database is an access database .mdb file when I trying to make a new data source for access file I can only see Microsoft.Jet.OLEDB.4....
0
votes
0answers
41 views

Multiserver administration - passing maintenance plans to clustered instances

SQL Server 2019 MSX/TSX environment. TSX servers are clustered instances. MSX is not. There is a SQL integration service on each of the nodes in the cluster. I create a maintenance plan on the MSX and ...
0
votes
0answers
15 views

Replication Monitor is not showing correct list of replications

I have one server, in which there are three instances of SQL Server 2019. In one instance, I had configured transactional replications, but all of those replications are currently dropped. But the ...
0
votes
1answer
42 views

Error using SQL Server 2019 Import and Export Data (64-bit)

I'm getting an error immediately upon starting the SQL Server 2019 Import and Export (64-bit) wizard, and I'm looking for ideas. The error is: The SSIS Data Flow Task could not be created. Verify ...
1
vote
0answers
37 views

SQL Graph DB Tables not supporting OLE DB Fast Load?

I try to use SSIS to load in SQL Server Graph DB an edge table, based on the documentation from MSFT it should behave like any normal table, if I use the OLE DB Destination with regular table load it ...
1
vote
1answer
28 views

Upgrading SQL 2016 AGs to SQL 2019 question

I am doing a rolling upgrade of my production SQL 2016 Servers to SQL 2019. I have availability groups. My current structure is 3 DR servers (secondaries), 3 HQ (on prem) secondaries and 3 HQ ...
0
votes
3answers
109 views

char or smallint for a column with numeric codes?

I have columns in my application that have values ​​that always have 4 digits, e.g. '0100' or '1230'. One of examples could be Merchant Category Code. For the time being, I have set the type of this ...
3
votes
2answers
287 views

Replication in sql server 2019? [closed]

I am reading 'Pro SQL Server 2019 Administration' book from Carter, and when detailing HA and DR options, 'replication' is not mentioned: Why is it omited? Will Replication be deprecated soon?
0
votes
1answer
54 views

Flag Rows Occurring 2 Hours After Previous Flag

I have some messy RFID data due to over sensitive antenna's. There is a physical process that tracks an RFID tag moving through different stations in a cycle. An item with an RFID tag can move through ...
-2
votes
0answers
30 views

How to setup SQL Server on VMWare for best performance [duplicate]

We have Dell r940 server with 64 CPUs. Processor Type: Intel(R) Xeon(R) Platinum 8253 CPU @ 2.20GHz 4 Sockets + 16 Cores per Socket and 128 Logical processors Memory 767 GB We set the server up on a ...
0
votes
1answer
36 views

Building a custom SQL Server 2017/2019 container on a windows server without internet

I am in bit of a predicament,and would appreciate any help to move forward from my current situation I have been given a VM running on Windows Server 2016 with Docker Enterprise installed. My ...
3
votes
0answers
133 views

After Upgrade/Migration to SQL Server 2019 Databases Periodically Gets Stuck In a Inaccessible State [closed]

I have a bit of a unique challenge, I have a series of test databases I use for CI type database testing, generally with each release I will restore (overwrite) these databases from a backup, update ...
-1
votes
1answer
51 views

MS SQL Server unexplained differences in query speed [duplicate]

I have a production database and staging database, they contain the exact same data, the production database was backed up and restored as the staging database. A particular operation (API call) ...
0
votes
2answers
31 views

Why am I getting error 35353 when enabling CDC on a table with a CCI?

I'm trying to enable Change Data Capture on a table with a clustered columnstore index, a unique non-clustered index, and a non-unique non-clustered index in SQL Server Standard 2019. The command ...
0
votes
2answers
29 views

What's the meaning of “resources external to the SQL Server computer are needed” in Microsoft's SQL documentation?

In Microsoft's SQL Server documentation on Windows service account configuration, the decision to use either a VA (virtual account) or a MSA (managed service account) hinges on whether resources ...
0
votes
1answer
66 views

How is the “Adjust memory quotas for a process” user right assignment used in SQL Server 2019?

I am looking at the Configure Windows Service Accounts and Permissions doc (https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-windows-service-accounts-and-permissions?...
0
votes
0answers
39 views

Where is the documentation for SQL Server's blocked process report?

I'm trying to work with the blocked process reports captured using Extended Events and, while I can find numerous blog articles and Q&A about specific details (e.g.1 2 3), I can't find any ...
0
votes
0answers
28 views

Disconnected replica when recovering from a forced failover

I'm evaluating disaster recovery using read-scale availability group on SQL Server 2019 and Windows 2019. The cluster type is NONE. The cluster works fine in general even when restarting replicas. The ...
0
votes
1answer
45 views

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

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.
0
votes
2answers
61 views

SQL Server 2019 Database stuck In Recovery state after restart [duplicate]

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 (...
1
vote
3answers
205 views

“Cannot continue the execution because the session is in the kill state” Error?

We use SQL Server 2019 Standard edition on Windows Server 2019. We have 200 users and thousands of connections at the same time. SQL Server 2019 raises an error Cannot continue the execution because ...
0
votes
1answer
64 views

What is the best way to store optional values in table?

I have a large table that will be partitioned (about 300 million rows). There are currently 57 columns in the table. At the moment we also have an 'Option' column, which is to hold values ​​that would ...
4
votes
2answers
114 views

Cannot reclaim Index Unused Memory in In-Memory OLTP

Steps to reproduce the problem Create a database with memory-optimized filegroup and container Create schema only in-memory table with nonclustered pk Simulate insert and delete activity. My result is ...
7
votes
0answers
139 views

2019 Enterprise - NOLOCK without NOLOCK, page latch time-out on tempdb and finally a dump

We have a very strange problem with a new SQL Server 2019 on a 2 new physical machines: Infrastructure: Starting a new installation of SQL Server 2019 Enterprise (15.0.2000.5 / X64 on Windows Server ...
0
votes
1answer
145 views

How to run Sql Server stored procedure in Async mode?

Is there a way to run SQL Server 2019 stored procedures with parameters asynchronously? Calls to this SP will be made several times a day, i.e. this is not one time requirement. Service Broker can be ...
-2
votes
1answer
38 views

SQL Services are off but can access and query from other server on the same domain. Why? [closed]

Using configuration manager, I disabled the SQL Server Services for a SQL Server 2008 R2 instance. Yet, I can still connect to the instance from its replacement server, a SQL 2019 box, and query the ...
0
votes
1answer
44 views

What is the best way to add optional update in procedure in transaction?

Currently I have a procedure that performs 4 operations in the Transaction: Update record in table A Update record in table B Insert record into table C Delete record from table D The first ...
2
votes
2answers
111 views

What is the best choose for PK in Partitioned Table?

I have one large table that is partitioned (table name: Trans). At the moment this table is to be created on 32 partitions. This table will contain approximately 300 million records and data older ...
0
votes
0answers
109 views

Internal error: An expression services limit has been reached [duplicate]

In debugging a problem the application is throwing the error: Internal error: An expression services limit has been reached. Please look for potentially complex expressions in your query, and try to ...
0
votes
1answer
37 views

How can I tell if TempDb is too big?

Let's say that someone wants to follow sage advice and properly setup TempDb and TempDb's log. But let's also say that the chosen sizes are almost certainly too big/aggressive. E.g. pretend we've got ...
2
votes
2answers
107 views

Check Orders that can be delievered with reducing quantity from stock

Just like any retail business we have an Orders table and an Inventory table. What I am trying to do is to check Orders for which we have enough stock available to dispatch. A few things I need to ...
0
votes
1answer
78 views

Query tables with 400 million records fast [closed]

Table: Customer Data Rows: 400 million Indexes: Non-clustered (as per queries) Issue: Index Scan happening with most queries, 400 million scan take too long to complete Need advise on how to address ...
0
votes
1answer
89 views

Simple query on sys.dm_db_partition_stats is running for 30 minutes

Simple query on sys.dm_db_partition_stats on user database is running for close to 30 mins where as it used to complete in less than 5 seconds earlier. Query is just to fetch the right partition for ...
1
vote
0answers
79 views

SQL Server 2019 and Transparent Data Encryption - Intermittent (silent) Error Log Messages

I recently migrated a SQL Server 2017 TDE database to SQL Server 2019 CU4. I was browsing the Error Log and noticed intermittent messages about An error occurred while processing log encryption. The ...
0
votes
0answers
12 views

How to setup transaction in partitioned table with Always On?

I am currently creating a project that will use a table that will contain around 40 columns (including varchar (max)) and will be partitioned. About 200-250 records per second are to be inserted into ...
0
votes
2answers
116 views

SQL Server 2016 -> 2019 AlwaysOn Rolling Upgrade Migration

I have a migration concept with an AlwaysOn configuration from SQL Server 2016 (on windows server 2016) to SQL Server 2019 (on Windows Server 2019) which are in different sub-networks. So with ...
0
votes
0answers
35 views

Strict in OPENJSON not work well

I've a table for save sub tasks data. some time we change status of sub tasks, and i need both of them id and status in @JsonStatus parameter. I wrote a stored procedure like below : Declare @...
4
votes
1answer
175 views

Not able to restore a backup to SQL Server 2019

I am trying to a restore a SQL Server from a .bak file and always get the same error : The database was backed up on a server running version 15.00.2000. That version is incompatible with this server,...
6
votes
1answer
116 views

Incurs_seek_penalty column of sys.dm_os_volume_stats

A new column, incurs_seek_penalty, was introduced in the SQL Server 2019 sys.dm_os_volume_stats DMF. This tinyint column is not currently documented. Does anyone have information about the enumerated ...