Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [sql-server-2019]

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

473 questions
34
votes
1 answer

SQL Server 2019 executes unreachable code

[Update: This question describes a bug which has been fixed in Cumulative Update 5 for SQL Server 2019.] Consider the following repro example (fiddle): CREATE FUNCTION dbo.Repro (@myYear int) RETURNS datetime AS BEGIN IF @myYear <> 1990 …
Heinzi
  • 3,075
  • 2
  • 24
  • 38
23
votes
1 answer

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 adaptation of Bw-Tree or Bz-Tree. However, these rely…
Michael Green
  • 22,481
  • 12
  • 46
  • 87
20
votes
2 answers

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 tried using the same syntax as Accelerated…
Brent Ozar
  • 41,112
  • 30
  • 166
  • 313
19
votes
2 answers

SQL Server in-memory optmized tempdb metadata memory usage continually growing

Problem We have enabled sp_configure 'tempdb metadata memory-optimized' = 1, and now the tempdb meta data is taking over 400 GB on one of our servers and continues to grow. There are some drops in memory usage, but generally it keeps growing it's…
SQLing4ever
  • 463
  • 2
  • 7
14
votes
1 answer

Does SQL Server 2019 have task scheduling differences between enterprise and standard editions?

In How It Works: SQL Server 2012 Database Engine Task Scheduling, Bob Dorr explains some of the changes for worker scheduler assignment in SQL Server 2012. He mentions that some of the improvements are only available in enterprise edition. Do these…
Joe Obbish
  • 29,978
  • 4
  • 56
  • 131
12
votes
1 answer

What is AzureAttestService?

We started the installation and configuration of SQL Server 2019 on Windows 2019 and noticed after install a new service named 'AzureAttestService' was running and set to automatic. Services list the Description and Group field also as…
SQLDBAND
  • 315
  • 2
  • 4
12
votes
1 answer

How is the new system stored procedure sys.xp_delete_files different from sys.xp_delete_file?

SQL Server 2019 introduced a new (and undocumented) system stored procedure: sys.xp_delete_files What, exactly, does this new extended stored procedure do? How does it differ from xp_delete_file that has been around for years? Does it replace…
Solomon Rutzky
  • 65,256
  • 6
  • 135
  • 267
12
votes
2 answers

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 example, changing an existing column data type…
gotqn
  • 3,559
  • 9
  • 40
  • 72
11
votes
3 answers

MERGE into a view with INSTEAD OF triggers

I have a view with instead of triggers and I'm trying to use it with EF Core, which tries to batch inserts together in a form of merge statement. Here's my table and view: create table tbl (id uniqueidentifier not null primary key, data…
torvin
  • 213
  • 1
  • 6
11
votes
3 answers

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: Failed to retrieve data for this request. …
Adam Kavan
  • 113
  • 1
  • 4
11
votes
2 answers

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 the included statuses. When it finds a record…
ZCT
  • 111
  • 1
  • 4
11
votes
3 answers

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?
Simon
  • 213
  • 1
  • 2
  • 6
11
votes
1 answer

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 2019. Everything in my application works fine…
dsungaro
  • 113
  • 7
11
votes
1 answer

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 surrounding query's. One consequence of this is…
Michael Green
  • 22,481
  • 12
  • 46
  • 87
10
votes
1 answer

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 the graph features allow us to quickly find all of…
Alan Deutscher
  • 101
  • 2
1
2 3
…
31 32