Questions tagged [sql-server-2019]

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

40 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
6
votes
1answer
218 views

Select permission denied when using linked server in a function unless inlining is off

We are encountering an unusual error in our beta environment after upgrading to SQL Server 2019. This occurs when selecting from a scalar-valued function. This error does not occur in our production ...
4
votes
0answers
112 views

hash join hint returning error when using local variable

DECLARE @Id INT = 18471 SELECT c.UserId FROM dbo.Comments AS c INNER HASH JOIN dbo.Users AS u ON c.UserId = u.Id AND c.UserId = @Id The query above using Stackoverflow 2010 database with hash join ...
4
votes
0answers
95 views

Can backups done through external clients cause memory pressure on SQL Server?

Developer in DBA role here, we recently migrated from 2008 to 2019 and are having memory related problems on the new server. Every 3 to 6 days the OS will start paging and CPU usage would spike to 99%,...
4
votes
0answers
138 views

How can Cumulative Updates to SQL Server 2019 be Slipstreamed into a Single Installer?

I'd like to take the latest version of SQL Server (SQL Standard, 15.0.2000.5), and apply the latest CU to it so that I have a single installer, thus reducing the size of the resulting package. The ...
4
votes
0answers
135 views

SQL Server 2019: Memory performance with graph queries (possible memory leak)

I'm currently working on implementing an upgrade to SQL Server 2019 in order to make use of the graph features that are available in it. Our database stores records of files and their children, and ...
3
votes
0answers
89 views

Turn off Error AND Usage Reporting SQL Server

Unfortunately, SQL Server usage internet bandwidth and us activity in SQL, for R&D. You can find in your server, this service is called: SQL Server error and usage. This service is active without ...
2
votes
1answer
28 views

Synchronize 2 sql server 2019 database over intermittent connection (no replication)

I'm a PostgreSQL DBA learning SQL Server 2019. The setup : 1 Desktop, 1 Laptop Both running SQL Server 2019 Developer Windows 10 Home (nothing else, no active directory, nas, san, ...) a database in ...
2
votes
0answers
85 views

Sql Server 2019 Query Hint Placement confusion

I'm using SQL Server 2019 (CU4) and I'm encountering some strange issues when trying to use a query hint for the legacy cardinality estimation due to a poorly performing Table Value Function. I'm not ...
2
votes
1answer
44 views

how to mirror an azure storage account to a non-paired zone to enable fast file_snapshot backup/restore and database file access?

Wow, that title was a mouthful. Scenario My dev server is restoring a copy of production data daily, anonymizing it, and creating a dev-grade backup for my developers to restore locally. We're running ...
2
votes
2answers
59 views

dbcc checkdb runs for interminably long time, 50% of the time

I've got a nightly maintenance job (largely taken from the ola hallengren maintenance package) that runs database backups and runs an an integrity check on every database. The integrity check part ...
2
votes
0answers
93 views

InitPersistentVersionStore failed after installing CU2 on multiple instances

I saw this on another post, but I can't comment on it. So I am opening a new one, but I am having a similar issue that Martin Guth had posted. It is odd, but I updated about 9 of my instances to CU2 ...
2
votes
1answer
51 views

sys.dm_db_file_space_usage not returning correct values in SQL 2019

Scripts I use for database space metrics on our SQL Server do not return the correct values for allocated_extent_page_count and unallocated_extent_page_count from sys.dm_db_file_space_usage when run ...
2
votes
0answers
47 views

SQL Server Agent is not ending some jobs correctly

we observed a strange behaviour after migrating our datawarehouse from SQL Server 2012 to SQL Server 2019. Our Agent runs most of the jobs correctly after the migration. However there are a few were ...
2
votes
0answers
226 views

PolyBase to CSV File

I'm trying to see if it's possible to create a PolyBase connection to a .CSV file. I'm using the Microsoft Access Text Driver and have set up a system DSN to the folder where the csv file is located. ...
2
votes
1answer
51 views

How can I successfully decrypt column data through the whole database safely?

We're moving to Azure SqlDb but as part of that, we're needing to migrate away from EncryptByPassPhrase as it's not supported. As such, we tried the process on the weekend but we ran into the log ...
2
votes
0answers
140 views

Problem with installation SQL Server 2019

I got a problem when I wanted to install SQL Server 2019. I don't have Setup Bootstrap on this path, I only have folders SSEI and License Terms on this path. Windows Installer log file: C:\Program ...
1
vote
0answers
20 views

mssql suddenly cannot access physical file

SQL server 2019 on Centos 7 x86_64. It was running fine for quite long time, then got broken. I was not doing anything special, neither update or restart or whatever. At some point the database went ...
1
vote
0answers
53 views

Why are column store indexes disabled automatically when a database is restored?

I have recently done a server migration where we backed up and restored all the databases from a SQL Server 2012 version to SQL Server 2019. However the restored databases appear to all have their ...
1
vote
0answers
73 views

SQL Server 2019 and TDE

We are about to move away from SQL 2008R2 to a much newer version. We upgraded to the Enterprise Edition of 2008R2 just for TDE, but I was just browsing here: https://docs.microsoft.com/en-us/sql/sql-...
1
vote
0answers
15 views

SQL Server - Change AuditLevel on Linux hosted instance

just wondering if it's possible to change the AuditLevel on SQL Server 15.0.1800.32 (2019) hosted on Linux to "Failed logins only". Currently it's set to audit failed and successful logins and I ...
0
votes
0answers
11 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
0answers
33 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 @...
0
votes
0answers
3 views

How to connect to Microsoft Dynamics Rms 2.0 Running sql2008r2?

Would anyone know anything about Microsoft Dynamics Rms 2.0 (2012)? We are having trouble connecting our sql server to the client side cashier (windows 10 pro) this software sunset in 2016 I believe ...
0
votes
0answers
6 views

Power BI Report Server keeps asking for credentials locally

I've installed PBIRS on my laptop to do some development. Each time try to connect it prompts with dialog wanting me to login. If I try and connect from a remote PC using the same domain login, it ...
0
votes
0answers
16 views

Primary Key and Unique Constraints in Partitioned Table

I am currently creating a project that applies to a table that contains about 40 columns (including varchar (max)) and will be partitioned. About 200-250 records per second will be inserted into the ...
0
votes
0answers
37 views

HA AlwaysOn and SMB File Share

I am planning on taking our current single 2014 SQL server and rebuilding it to a 2019 SQL Server HA AlwaysOn Cluster. The issue is, the listener IP and hostname has to stay the same and many years ...
0
votes
0answers
13 views

Windows Server 2019 non-owner node cannot see Cluster Name or IP

I am trying to build a SQL Server AlwaysOn Availability Group with 2 nodes in Azure. I have created 2 SQL Server VMs and Managed to create a Cluster with both Nodes as members of that cluster.  I ...
0
votes
1answer
58 views

SQL Server 2019 Always On using Distributed Network Name

We're running a couple SQL servers in Azure that are set up with an Always On availability group and Windows Failover Clustering. The servers are Windows 2019 and we're running SQL Server 2019. When ...
0
votes
0answers
54 views

SQL Polybase - Connect to MySQL ODBC - Issue with decimal data type

hope someone has a clue about this... I'm using SQL 2019 Polybase to connect to a MySQL 8 Server using an ODBC (MySQL 8.0.20 ODBC Driver). CREATE EXTERNAL DATA SOURCE eds_test1 WITH ( LOCATION = '...
0
votes
0answers
32 views

Problem with installation Polybase in SQL SERVER 2019 on local instance

I am trying to install Polybase on SQL Server 2019 but in process of instalation I got following error: [ZARZĄDANIE NT\USŁUGA SIECIOWA] is [NT AUTHORITY\SERVICE]. I was also trying [NT AUTHORITY\...
0
votes
1answer
22 views

How to name tables which are responsible for storing dictionaries and configuration?

Below I attached diagram which corresponds to part of my database : My questions: In your opininon Do I have to divide ServiceInsance and ConfServiceInstance ? I did it like that because I would ...
0
votes
0answers
36 views

SQL 2019 Database Engine Service Stopped

I'm having an issue with my new SQL 2019 server. It seems that randomly the Database Engine service is stopping. It has happened 4 times over the last 3 weeks. There is no pattern as to what days/...
0
votes
0answers
24 views

SQL Server Mirrored Backups proceed as single location backup if errors: How to do that?

**The problem ** I am currently experimenting with Mirrored Backups for the first time. Imagine a backup command like this: BACKUP DATABASE [myDB] TO DISK = N'B:\DB_Backups\myDB_FULL_20200318_083821....
0
votes
1answer
36 views

Piecemeal Restore: Can you add new filegroups during the restore?

I have a SQL 2019 Standard instance and am currently fiddling around with piecemeal restore in order to be able to restore a database more quickly. What do I try to achieve? The database has ...
0
votes
0answers
7 views

Change PBIRS Layout

Does anybody know if it is possible to change the color of the PBIRS Reporting Portal. Currently its only black and we did not found a way so far to change it. Thank you...
0
votes
0answers
53 views

Should I install all cumulative updates/service packs when doing a clean install of SQL Server 2016? 2019?

Going to set up a new database instance from scratch. Debating between SQL Server 2016 and 2019. I've never installed a service pack or cumulative update on previous instances, mostly because ...
0
votes
0answers
33 views

Best Practice: Persisted Computed vs Computed with Index vs?

I am an accidental DBA charged with performance tuning a mess of queries (both literal, and figurative). One pattern we have is to always store Dates as DateTime2(7) regardless whether we need the ...
0
votes
1answer
68 views

SQL Server Restore Disk Response Time

So I have a new SQL Server in place. I have a 200GB database I am trying to restore to this new server and the restore time is taking longer than my current server. My new server has a RAID 10 for ...
0
votes
0answers
561 views

Microsoft SSMS 2018 cannot open (only the splash screen)

yes, i've read this SQL Server Management Studio 18 won't open (only splash screen pops up) , it work the first time. after i restart my computer, and try to open smss again, the problem happen ...
0
votes
0answers
51 views

SQL Server 2019 Developer Edition on Ubuntu 18.05 Linux seems to only use one processor

I set up this db on an old server that has Ubuntu 18.04 in order to test some new features of SQL Server 2019. First time running SQL Server on Linux. I am running an intense query and happened to ...