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
1
vote
0answers
16 views

I would like to migrate SQL SERVER 2014 to SQL SERVER 2019 on Linux using AG

I would like to migrate SQL SERVER 2014 on Windows to SQL SERVER 2019 on Linux using while running AG. Is there an option to Add the SQL SERVER 2019 to the same AG and once the time comes gracefully ...
8
votes
2answers
3k views

Dodgy T-SQL Query Execution driving me crazy

SQL Server 2019. Here's a link to a gist with the xml plan. Hello, I am having a heck of a time understanding why this query is taking 0.02 seconds to execute when it can't find a record with one of ...
3
votes
2answers
345 views

Upgrading from SQL Server 2012 SP1 to SQL Server 2019

I'm upgrading an internal database at work, and we are creating a new VM to host it. I can't see an option to generate a script to export the SQL Server 2012 SP1 database for server version SQL ...
5
votes
1answer
183 views

After SQL restart, CTE causes invalid object name error for a short period in SQL Server 2019

We have some SQL code that has been in production for some time, in a SQL Server 2016 database; but it is raising an error in a SQL Server 2019 database for the first hour or so after restarting SQL ...
0
votes
1answer
44 views

SQL Server AlwaysOn AG Secondary Replica is not joined [closed]

I have created an Availablity Group on SQL Server 2019. I selected 2 SQL server for Replicas but the Secondary replica has an error: This secondary database is not joined to the availability group....
0
votes
1answer
32 views

SQL Server AG secondary replica database still in Restoring mode

I created an AlwaysOn in SQL Server 2019 and I selected the Full Database and Log Backup option. Now it created a database in secondary replica but it is still in Restoring mode. My DB size is 16MB ...
-2
votes
1answer
45 views

Does SQL Server 2019 honor OPTION (USE HINT ( 'FORCE_LEGACY_CARDINALITY_ESTIMATION' )) [closed]

We had several pieces of code that when the 2014 Cardinality Optimizer came out performed very poorly. By adding this oip
3
votes
1answer
102 views

SQL Server AlwaysOn Availablity Group Automatic seeding

I created an AlwaysOn in SQL Server 2019 and I selected Automatic seeding, but it does not create my database in secondary nodes, On the other hand, if I create my database manually I give and error ...
0
votes
0answers
55 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
23 views

Smearing values in SQL server that inserts new rows

I was reading this article: https://www.red-gate.com/simple-talk/sql/t-sql-programming/filling-in-missing-values-using-the-t-sql-window-frame/ . This shows how to smear data using quirky update, and ...
0
votes
0answers
21 views

ALTER TABLE ADD [duplicate]

I have a development SQL Server (SQL 2017) and a production one (SQL 2019). When I run the following statement on dev it is pretty much instantaneous ALTER TABLE dbo.BatchStaging ADD ...
0
votes
2answers
91 views

Does MS SQL Server have generate_series function

Does MS SQL Server have Series Generating Function(s) (aka generate_series) like Postgresql has. If not is there a basic way to implement the function? Timestamp version is preferred I found this ...
1
vote
1answer
38 views

Explanation for second Compute Scalar

I noticed a peculiar thing. This query declare @t int = 3; select distinct top(@t) Number - Number + ABS(CHECKSUM( CAST(NEWID() as binary(16)) )) from Numbers as n; produces this plan dbo....
1
vote
0answers
43 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-...
3
votes
2answers
339 views

Where to download SQL Server 2019 Express LocalDB Installer MSI from

SQL Server 2019 is released but I there doesn't appear to be a LocalDB version available for download. Does anyone know if there will be a LocalDB release or if 2017 is the last version?
3
votes
1answer
124 views

Allowing non-privileged users to cause privileged code to run

Context: Our SQL server is used for teaching, and we need to be able to automatically create databases for the students on demand and in real-time. We also need the students to be able to delete ...
0
votes
1answer
47 views

Limit TLS and Cipher Suites on SQL Server 2016-2019

I'm wanting to configure some SQL 2016+ servers to use only TLS 1.2+ and a subset of Cipher suite options (no ciphers considered weak or compromized). I'm having trouble tracking down how to ...
11
votes
1answer
587 views

After upgrading to SQL Server 2019, function throws “insufficient memory” error

I have moved an SQL Server 2012 Database (8GB in size) to a newly setup SQL Server 2019 virtual machine with the same memory and CPU configuration and changed the compatibility level to SQL Server ...
1
vote
0answers
89 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. ...
3
votes
1answer
67 views

Getting all undeclared variables from query

Imagine you try to run the following query: SELECT * FROM dbo.Customers c WHERE id = @id AND dateTimeCreated = @date You'll get an error message along the lines of Must declare the scalar ...
2
votes
1answer
25 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 ...
1
vote
1answer
346 views

Upgrading SQL Server 2019 from CTP to RTM version

A few days ago Microsoft announced RTM version of SQL Server 2019 finally and we are willing to install and use it on our business intelligence server. We are already using Microsoft SQL Server 2019 ...
11
votes
1answer
148 views

Inline Scalar UDF Under RCSI - Can Results Differ

SQL Server 2019 introduces Scalar UDF inlining, aka "Froid." This ".. embeds [scalar UDFs] in the calling SQL query." Previously, scalar UDFs ran under their own execution context, separate from the ...
2
votes
0answers
84 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 ...
0
votes
1answer
322 views

Replication problem in SQL Server 2019

I have installed SQL Server 2019 RC1 and cannot create a snapshot. I keep getting the same message when I run the snapshot agent: 2019-10-30 12:32:41.59 Microsoft (R) SQL Server Snapshot Agent 2019-...
0
votes
1answer
22 views

Why does a fresh SQL Server instance with the same details as the original think that my DB backup is in the original location?

So I'm working on a server application for a large government body and need to setup a development environment to test on. For this I'm using a Vagrant-controlled VM with Windows Server 2019 installed ...
-1
votes
1answer
139 views

Data sensitivity classification in SQL Server 2019

Is there any way in SQL Server 2019 to physically partition data by Data Sensitivity Classification and thereby allow different security mechanisms to be used with different sensitivities? New ...
3
votes
2answers
276 views

When should the IGNORE_DUP_KEY option be used on an index?

Someone said it's preferable to craft your queries to avoid duplicate key exceptions, but I'm not convinced that's more performant that just setting IGNORE_DUP_KEY = ON for the index. My goal is to ...
-4
votes
2answers
167 views

In the following inventory system, is it possible to force row locks to avoid deadlock and ensure it works as intended? [closed]

I want to atomically reserve inventory for N objects for M users. I have two inventory tracking tables, one for global inventory and one for personal inventory. Global Inventory Table Columns: ...
1
vote
0answers
13 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 ...
18
votes
0answers
457 views

Implementation and contraindications for OPTIMIZE_FOR_SEQUENTIAL_KEY

SQL Server 2019 CTP3.1 introduced an optimization to address last-page insert contention. This takes the form of an index option called OPTIMIZE_FOR_SEQUENTIAL_KEY. One imagines this could be an ...
8
votes
1answer
105 views

initdata: No memory for kernel buffers

I recently upgraded my SQL Server 2017 Developer Edition on RedHat Enterprise Linux 7.6 to SQL Server 2019 CTP 3.0. The mssql-server service will no longer start. /var/opt/mssql/log/errorlog shows ...
0
votes
0answers
350 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 ...
5
votes
3answers
181 views

“tempdb metadata memory-optimized” configuration option

Checking SQL Server 2019 CTP 2.5 (15.0.1500.28) I found this new configuration option and was wandering what is behind it. Couldn't find any information so far and was wondering if you know where to ...
2
votes
1answer
89 views

SQL Server Demo Environment on Docker Desktop (Win 10): DB storage und upgrade paths

I would like to run SQL Server 2019 on my work as well as my private machine (both running Windows 10 Pro). Thus I thought Docker Desktop would be a nice option. However I would like to keep the ...
0
votes
0answers
48 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 ...
0
votes
1answer
69 views

Can an AlwaysOn Availability Group be used to mitigate downtime when there's replication syncing issues on the primary server?

Once in a while I'll run into syncing issues with my subscriber server in a transactional replication setup. Taking a new snapshot of the publisher causes significant downtime on my subscriber server. ...
20
votes
1answer
3k views

How do you enable SQL Server 2019's result set caching?

SQL Server 2019 CTP 2.3 added a few new columns to sys.databases, including is_result_set_caching_on: It's not documented yet in the What's New in SQL Server 2019, nor in the ALTER DATABASE page. I ...
6
votes
1answer
379 views

Execution plan doesn't show memory grant

I installed SQL Server 2019 on a VM on Azure (DS11). I am trying to illustrate adaptive query processing using this post here. The issue is that when I hit CTRL+L in SQL Server Management Studio to ...
2
votes
1answer
489 views

SQL Server 2019 CTP 2.1 on Ubuntu fails after powering off

I've installed Microsoft SQL Server 2019 (CTP2.1) - 15.0.1100.94 (X64) on my VirtualBox Ubuntu 16.04.5 LTS. Everything seemed to work properly until I've powered off the machine. Since then SQL Server ...
10
votes
2answers
2k views

When `nvarchar/nchar` is going to be used with SQL Server 2019?

With SQL Server 2019 Microsoft introduces UTF-8 support for CHAR and VARCHAR data types and says: This feature may provide significant storage savings, depending on the character set in use. For ...