Stack Overflow
Stack Overflow

Questions tagged [sql-server-2019]

Use this tag for questions specific to the 2019 version of Microsoft's SQL Server.

New Features Of SQL Server 2019

  1. Intelligent Query Processing Enhancements enter image description here
  2. Accelerated Database Recovery (ADR) enter image description here
  3. AlwaysEncrypted With Secure Enclaves enter image description here
  4. Memory-Optimized Tempdb Metadata
  5. Query Store Custom Capture Policies
  6. Verbose Truncation Warnings
  7. Resumable Index Build
  8. Data Virtualization With Polybase enter image description here
  9. Last Actual Execution Plan DMF
  10. Multiple Internal Performance Improvements

Reference : What's new in SQL Server 2019 (15.x)

426 questions
14
votes
4 answers

Restore database in docker container

Getting an error below when restoring a AdventureWorks2017 database within a docker container. Running SQL Server 2019 CTP 2.0 (mcr.microsoft.com/mssql/server:vNext-CTP2.0-ubuntu) Both backup and target data volume are persisted. No problems…
Daniel N
  • 723
  • 4
  • 13
7
votes
2 answers

Unexpected @@rowcount behavior inside an UDF in MS SQL 2019

here's my sample code drop function rowcount_test go CREATE FUNCTION dbo.rowcount_test () RETURNS INT AS BEGIN DECLARE @v INT SELECT @v = 1 return @@ROWCOUNT END GO grant exec on dbo.rowcount_test to public go SELECT…
pelod
  • 73
  • 4
6
votes
2 answers

Get Orders status that can be delivered with reducing quantity from stock without curson or While loop

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 consider: If all the items in an order are…
Jack Jones
  • 135
  • 1
  • 1
  • 7
6
votes
1 answer

SQL Server machine learning services r version 3.5

According to this link, SQL Server machine learning service's highest R version is 3.3. Does anyone know when one can upgrade to version 3.5 or later? Or is my only option to switch to sql server 2019? Thanks.
cs0815
  • 13,862
  • 32
  • 107
  • 253
6
votes
1 answer

SQL Server 2019 Behavior change with scope of SET IDENTITY_INSERT ON/OFF

We are migrating to SQL Server 2019 RTM version and noticed that one of our stored procedures that uses SET IDENTITY_INSERT ON/OFF statements are failing which works properly in SQL Server 2017 and earlier. Even changing the compatibility level to…
Gan
  • 91
  • 5
4
votes
2 answers

Select most recent value in a group

I'd like to add the column LastSalePrice to the query below: SELECT P.SKU, C.TotalSales, MIN(C.MinPriceChannel) OVER(PARTITION BY P.SKU) AS MinPrice, MAX(C.MaxPriceChannel) OVER(PARTITION BY P.SKU) AS MaxPrice, P.ProductName, …
Ortiga
  • 7,687
  • 5
  • 37
  • 64
4
votes
2 answers

Unable to debug .NET after VS 2019 upgrade

I was using the VS 2019 to debug a SQL Server CLR C# .NET code. I got an upgrade notification from VS which I did and rebooted. I now get the error when trying to debug Unable to debug .NET code. Could not attach to SQL Server on '....'. The 64…
Ben Watson
  • 121
  • 6
4
votes
2 answers

SQL Server 2019 - The server principal "sa" is not able to access the database "DB_NAME" under the current security context

I've written the following stored procedure: CREATE PROCEDURE dbo.usp_DEMO @LOGINSQL VARCHAR(30), @DBNAME VARCHAR(40) WITH EXECUTE AS owner AS DECLARE @SQL NVARCHAR(1000) SET @SQL = 'USE' SET @SQL = @SQL + ' ' + @DBNAME + '…
AdemirP
  • 61
  • 2
  • 8
4
votes
0 answers

SQL Server Agent Job stops SSIS Step with "unexpected error" and without any error informations

I am dealing with my problem on some Windows Server 2019 (Core) with one running SQL Server 2019 CU4 instance each. What we try to do We are currently building a data warehouse with distributed databases. The individual layers of the DWH are…
user_AL
  • 66
  • 6
4
votes
2 answers

Quiet (unattended) install of SQL Server Express LocalDb 2019

With SQL Server Express LocalDb 2012 (Microsoft MSI download) it was possible to do an unattended install from a command line: msiexec /i SqlLocalDB.msi /qn IACCEPTSQLLOCALDBLICENSETERMS=YES This works pretty stable for me on various versions of…
msporek
  • 1,088
  • 7
  • 20
4
votes
1 answer

SQL Server Import Wizard doesn't support importing from excel sheet with more than 255 columns

I use the SQL Server 2019 Import and Export wizard to import an Excel sheet (xlsx file) as source and I set the destination as a SQL Server table. In the wizard setup I setup the mapping for all the columns in Excel to the SQL Server table. After…
choba78
  • 301
  • 2
  • 4
  • 11
4
votes
1 answer

Polybase doesn't create external file format

I get the good old Incorrect syntax near 'EXTERNAL'. error. I am exactly doing what this answer describes. But SQL Server returns the aforementioned error when I come to this code-chunk: CREATE EXTERNAL FILE FORMAT csvformat WITH ( …
5th
  • 1,366
  • 1
  • 15
  • 30
3
votes
1 answer

Find Columns which starts with Lowercase letters in SQL Server Data Base and list them as a SELECT Statement

i am trying to Select All Columns in a Database Which Started With Lower Case Letters . Like 'status'. i Wrote a Command As Below : SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE LEFT(COLUMN_NAME, 1) = 's' I Got The First Letter And Checked It IF…
Iman S3
  • 76
  • 7
3
votes
1 answer

SQL Server 2019 breaks Base64 encoding as a Scalar-valued Function

I have a Scalar-valued Function that I've been using for years in my database. Its always worked correctly. I recently moved the database to SQL Server 2019 and when I changed the compatibility level to SQL Server 2019 (150), my function blew up…
jscarle
  • 703
  • 3
  • 12
3
votes
1 answer

Unable to connect to (localdb)\MSSQLLocalDB - Due to trigger execution

I have a SQL Server Express instance on my machine that had been working fine and I have no idea what changed. I get this error now: Logon failed for login 'myusername' due to trigger execution. Changed database context to 'master'. I have tried…
gecclesinc
  • 101
  • 1
  • 6
1
2 3
…
28 29