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
0answers
17 views

SQL Server 2019 on Ubuntu Throwing security.crypto.symkey errors

I'm repeatedly seeing the following error, seemingly for every connection to SQL: 04/06/2021 16:39:25.890647613 Error [security.crypto.symkey] <0000004241/0x00000c34> Setting Variable Length ...
1
vote
1answer
53 views

Clone a database from SQL Server 2019 to 2017 [duplicate]

I try to clone a database from an Sql Server on my local machine v15 (2019) to a server machine v14(2017). I did a .bak file and when I tried to import on the server side it says: System.Data....
0
votes
0answers
41 views

Can Microsoft JDBC Driver 4.0 connect to SQL Server 2019 and perform DML without issue?

The SQL version compatibility BOL article advises that the minimum compatible JDBC driver version for SQL Server 2019 is 7.4. Can an older JDBC driver still connect to SQL Server 2019? Or can only the ...
2
votes
3answers
324 views

Critical query plans removed from sys.dm_exec_query_stats while trivial items are kept [duplicate]

Running SQL Server Express 2019. Have a complicated stored procedure containing 11 sql statements (when selected from sys.dm_exec_query_stats by plan_handle). 9 of those statements are simple variable ...
2
votes
2answers
109 views

Fast recovery vs Accelerated database recovery in SQL server 2019

while comparing the features available in different SQL server editions, i see that Fast recovery and Accelerated Database recovery are 2 separate features. I am unable to find any documentation ...
1
vote
1answer
45 views

SQL Server Cluster and Windows Server Storage Replication

I am currently investigating on how to setup a SQL Server stretch cluster in combination with storage replication for which I want to use Windows Server Storage Replication. However, I am no sure on ...
2
votes
1answer
50 views

Schema binding seems to not be enforced for view doing temporal query

I am using Microsoft SQL Server 2019. There are two strange behaviors that I don't see documented (if it is, please point me to the Microsoft docs link), I suspect they're related. The ...
1
vote
2answers
81 views

SP runs slower on new server

We migrated our databases from SQLServer 2012 to SQLServer 2019. Our ETL's are build in Visual Studio and are set up from a master package. The masterpackage calls on different packages, which are not ...
0
votes
1answer
15 views

Accelerated Database Recovery with AlwaysON — long recovery time for secondary unexpeccted

So I was intrigued by the new SQL 2019 Feature Accelerated Database Recovery. It has some great use cases, such as being able to kill a long-running transaction and have it instantly rollback. I had ...
0
votes
0answers
66 views

SQL Server 2019 replication problem after update to CU9

After update to CU9 for SQL Server 2019 (15.0.4102.2) (Linux Ubuntu 18), replication (snapshot) stopped working with errors: 2021-03-23 11:58:08.70 [0%] The replication agent had encountered an ...
1
vote
1answer
26 views

Running Excel addin for MDS2019 vs MDS2016

We are upgrading master data services (MDS) of SQL2016 to SQL2019.Is there a way to run excel 2019 addin for connecting to SQL 2019 MDS along side(parallely) with excel 2016 addin for connecting to ...
1
vote
0answers
40 views

SQL Always on Availability Groups Direct Seeding

Setting up a new SQL cluster and HA using SQL Availability Groups. SQL 2019 STD 2 Node Multi Subnet Basic AG Primary Node AWS Secondary Node VMWare on premise I am using the newer Automatic Seeding ...
-1
votes
1answer
27 views

Migration from SQL SERVER 2008 R2 to 2019 with Log Shipping [closed]

Is possible to run swing migration from SQL SERVER 2008 R2 to 2019 with Log Shipping?
0
votes
1answer
27 views

SSAS error deploying project: Ensure that 'SQL Browser' service is running

After successfully building my project, I got this error when deploying it: The project could not be deployed to the '\SQLEXPRESS' server because of the following connectivity problems : A connection ...
1
vote
1answer
39 views

SQL Server 2019 using Linked server to Oracle 19c (19.9) using Oracle 19c client on Windows - DBCOLUMNFLAGS_ISNULLABLE error

Having issues selected data for some Oracle tables over the linked server from SQL Server: select type, count(*) from RMTDB..JOB1308.HOST_INTERFACE group by type order by 1 desc; Msg 7356, Level 16, ...
0
votes
1answer
96 views

Counting MAX event simultaniusly (based in datatime2) within a tallytable

Hi, I have a task that is meant to summarize several connections coming in to a given set of ports (trunks), into timeslots and count the results. The thing is that I would like to achieve two type of ...
1
vote
2answers
58 views

Tempdb log growth 3x as slow on new server, SP does not perform

We are running into the issue that our stored procedure on our new SQL Server performs a lot slower than on the old server. We looked into the problem and noticed the following on our temp db. The ...
0
votes
1answer
50 views

Store Procedure, Group multiple tables by time interval to new table: daily run schedule

Currently working on a thesis where I have been tasked with aggregating data to a new table I'm trying to build out an aggregated table where I'll store each row group by date and a time interval (let'...
2
votes
1answer
60 views

“Persisted” column is not used

I have a table with the following structure: ItemID int ItemType char(1) Language char(2) Localization char(2) Literal nvarchar(4000) which is used to translate ...
0
votes
0answers
52 views

Using Office 365 as mail server with SSRS 2019 on Server 2019 Azure VM - error message 'Failure sending mail:'

We have a Windows Server 2019 with SSMA 2019 installed. We also use Office 365. in the mail settings I have smtp.office365.com, and a the username and password for an account that is set up in our ...
1
vote
1answer
44 views

An INSERT statement triggers the SQL Server Audit to write it down in the logs although INSERT is not listed as an Audit Action

Background: I am trying to keep a track record of what users are querying in the database. One option I found is to create a Server and Database Audit Specification. I did not want to include INSERT ...
1
vote
1answer
95 views

Restore of copy_only backup of encrypted database made without FORMAT but with INIT fails

I have a task of making periodical copy of the database, twice a day, and I should not break any backup chain niether accumulate these temporary backups. So I tried to take a copy_only backup with ...
2
votes
2answers
124 views

Why is my SQL Server consuming so much memory?

I have a 64GB Windows Server 2019 Standard server in my TEST Server. I have SQL Server 2019 CU9 Developer Edition and my the instance is consuming 21,199 MB as shown in sql_physical_memory_in_use_MB. ...
3
votes
2answers
123 views

How do I fix the Code Page in SSIS Lookup Transformation to be 65001?

I have an SQL server 2019 with databases and tables all set with the collation Latin1_General_100_CI_AS_SC_UTF8. The relevant table has code and desc columns which are both of data type varchar. In ...
0
votes
1answer
17 views

Bulk DELETEs in publisher breaking SQL Server Replication in subscriber

We have SQL Server replication set up between 2 databases running SQL Server 2019. Every night, a SQL Agent job runs on the publisher that deletes all the data from a table and then rebuilds the ...
0
votes
1answer
69 views

SQL Server 2019 (RTM) - 15.0.2000.5 period has expired after upgrade to CU 8 [closed]

Hi i have MS SQL with version Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64) Sep 24 2019 13:48:23 Copyright (C) 2019 Microsoft Corporation Enterprise Evaluation Edition (64-bit) on Windows ...
0
votes
0answers
25 views

SSIS - DMA doesn't support migration assessment to SSIS in local SQL Server 2019

we will migrate from SQL Server 2008 R2 to SQL Server 2019 in near future, we already run DMA to analyze database, however DMA 5.2 doesn't support migration assessment type for intergration services (...
0
votes
1answer
50 views

Linked Server to Oracle error ORA-01804

Migrating SQL Server to a new machine. Migration involves setting up a number of linked servers, some SQL Server, Oracle and Teradata. No issues with SQL Server or Teradata servers, but every Oracle ...
1
vote
2answers
33 views

Bypassing version store for changing column datatype

Database is Always On High Availability synchronised database on SQL Server 2019 with READ_COMMITTED_SNAPSHOT on and we are updating datatype from varchar to nvarchar (with "alter table" ...
0
votes
1answer
62 views

Recursive CTE to get Grandparent, parent, children [duplicate]

I have a data structure that relies on a parent/child model. The top level parent can have multiple children where they can also be parents. Here's an example of how things can look in the tree: ...
0
votes
2answers
69 views

A slow query on MS-SQL-Server 2019 cannot be optimized

In the following thread I received some important and valuable information on how I can improve a slow query on MS-SQL-Server 2019. However, that didn't do very much. First I deleted all non-clustered ...
0
votes
3answers
78 views

Backup sqlserver 2019 and restore to Sqlserver 2017

I have only 1 table in SqlServer 2019 that I want to backup and restore into SqlServer 2017 in different server. To SqlServer 2019 I have access to server and with SSMS but to SqlServer2017 I have ...
0
votes
1answer
40 views

Does the length of the fields play a role in index access in MS-SQL?

Last week I had already started two threads dealing with slow SQL selects that probably did not use the index. Today I noticed the following: The customer and the material are involved in almost all ...
0
votes
1answer
23 views

Can no longer connect to localdb after updating from Sql Server 2016 to 2019

I need to restore a backup for an assignment, but SMSS said I was running v13 while the backup was made in v15. So I download and installed SQL Server Express 2019 and uninstalled the older version. ...
1
vote
1answer
51 views

SQL 2019 Linux, slow at GUI fast at sqlcmd/Query Analyzer

Server information OS Redhat 7 Memory 100GB CPU usage 1% User db size 2 gb each on avg total 7 user databases SSMS installed on a jump server Azure Data studio is also installed App Gui on application ...
3
votes
3answers
93 views

How do I determine the correct index on MS-SQL-Server based on a select?

I have two questions about the index management of MS-SQL-Server 2019 If the term "table scan" appears in the execution plan, is that an indication of a "full table scan", and ...
1
vote
6answers
236 views

MS-SQL-Server 2019 is slower than SQL-Server 2008

Since we updated from SQL Server 2008 to 2019, the queries have become much slower. The following query ran for ten minutes on version 2008. On version 2019 it runs for over 30 minutes. Until ...
3
votes
1answer
290 views

Can you switch recovery mode to simple from full in an Always ON cluster setup?

I need help understanding my options. Given: SQL server cluster setup that is maintained by a DBA. System is NOT in production yet (not handed over to the customer). Initial high volume push of data ...
2
votes
1answer
24 views

SQL Server AG Worker Threads

So, I'm currently trying to wrap my head around worker threads for availability groups, more specifically, the number of threads used by each secondary database. The information I've read is different ...
2
votes
0answers
426 views

SQL Server 2019 update CU8 to CU9 - lots of messages in errorlog file… DBID: [9] No DEK update for File Id [4] while existing DEK is null

This is SQL Server 2019 CU9 Developer edition on my 16GB laptop: I updated from CU8 to CU9: I ran checkDB on all of my DBs no issues. Lots of these messages in my SQL Server Log file viewer: DBID: [9]...
1
vote
1answer
29 views

SQL Server 2019 setting Force Encryption with a script

I have to update 50+ servers to use encrypted connection strings. Is there a way to script setting Force Encryption and TrustServerCertificate (e.g Powershell, or ???) so that I don't have to open ...
0
votes
1answer
23 views

What happens to a SQL Server 2019 Standard instance with an Annual Subscription Licence when it expires?

We have 3 production SQL Server 2019 standard instances which we have licenced through a third party supplier on an annual subscription basis. In our use case this works out cheaper if you only ...
2
votes
1answer
77 views

SQL Server 2019 running 100% on only 1-2 cores with MAXDOP 8 to 14

Here is the background on this issue. I am inserting slightly over 1 million records into a table from within a C++ program using ADO. One row at a time is read in from flat file and converted info a ...
0
votes
1answer
31 views

how to implement read-only rows or snapshots of rows

In my application I have objects with 3 levels of hierarchy. To model this in SQL Server, I have a ParentObject table with an Id column, ChildObject table with an Id and a foreign key ParentObjectId, ...
1
vote
1answer
38 views

Linux Volumes for SQL Server + Docker on Linux [closed]

I am testing out a POC project for SQL on Docker containers on Linux and wanted some background info on how to request the storage on the Linux VM. The plan is to spin up 10 containers with SQL 2019 ...
0
votes
1answer
27 views

Create LINKED SERVER to MYSQL using SSH

Is there any way to create a MS SQL Server Linked Server to connect to MySQL through SSH? I managed to connect to MySQL through SSH using other database management tools like HeidiSQL or DBeaver, ...
0
votes
1answer
43 views

Cannot find sqlserver service

I installed Sql Server 2019 in Windows PC. In Sql Server Configuration Manager into SQL Server Service I stopped all the instances. But still I can loggin to Sql Server via SSMS.why is that? Where is ...
0
votes
1answer
65 views

SQL Server 2019 install - Python and R failing

I'm installing SQL 2019 Enterprise on the first node of a failover cluster. Everything successfully installs except Python and R. Error messages are as follows: Feature: ...
0
votes
2answers
27 views

Open Windows Causing Locks After Sproc has Completed [closed]

I had a query that was being blocked. Ran sp_whoisactive @ get_locks=1 and identified the blocking query and it's owner. The result indicated the table had been locked for over four hours. The ...
0
votes
1answer
66 views

STRING_AGG Not Recognized on V15.0.2 of SQL Server LocalDB

I recently coded a stored procedure on SQL Server 2019 (14.0.3192.2) in AWS that utilized the function STRING_AGG with no issues. When I moved the code to my local test db it complained about that ...

1
2 3 4 5 6