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)

977 questions
4
votes
1 answer

Invalid Column Name issue with SSMS 18

I just installed SQL Server 2019 Express, and SSMS (18.9). I also downloaded the AdventureWorksDW2019 Database from Microsoft. I successfully set up my connection. I've already tried doing this -> Enable IntelliSense: For all query windows, please…
Elijah M
  • 43
  • 4
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
  • 8,455
  • 5
  • 42
  • 71
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
  • 7
4
votes
1 answer

Problem with scalar UDF inlining in SQL Server 2019

The function below will fails when I run it the first time with the following error: 8124 (Multiple columns are specified in an aggregated expression containing an outer reference.) The second time I run it it runs normally. If I remove…
arildh
  • 43
  • 4
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
  • 2,097
  • 3
  • 22
  • 41
4
votes
1 answer

JSON_MODIFY is not working properly in SQL Server 2017

Here is my code: DECLARE @info NVARCHAR(MAX) = '{"searchQuery":{"reportType":"ReportedHcEcg"},"pageQuery":{"pageNumber":1,"pageSize":10,"sortColumnName":"Urgent, UploaDateTime","sortOrder":"Desc"}}' SET @info = JSON_MODIFY(@info,…
Maulik Modi
  • 1,205
  • 12
  • 22
4
votes
5 answers

Edit asterisk symbol into list of column names in SSMS by wildcard expansion

How to change * [asterisk symbol] into list of column names? I can view the list of column names after placing mouse cursor over the *. Is it possible to click-crack on something to change the * into names without running the script an inserting the…
Przemyslaw Remin
  • 6,276
  • 25
  • 113
  • 191
3
votes
4 answers

Fill missing dates given ranges of dates

I have a table full of start and end dates like Start End 2023-05-19 20:00:00.000 2023-05-22 05:30:00.000 2023-05-22 05:30:00.000 2023-05-24 11:30:00.000 I would like one select query that returns all of them split…
Ashton
  • 35
  • 5
3
votes
1 answer

Entity Framework truncating decimal places when updating table

I have a table with a decimal(18, 3) column. The table maps to a class with the corresponding decimal property. I change the value of the property to, e.g. 0.035, and this is the command that is generated by EF to update the column: exec…
Ivan-Mark Debono
  • 15,500
  • 29
  • 132
  • 263
3
votes
0 answers

SQL Server Collation to Match SSIS Ordering

Example values from a SQL Server data set as they appear after an ORDER BY clause: X0000000-2009 X000000-1-2010 X0000001-2010 If I use ORDER BY Field COLLATE Latin1_General_bin they come out slightly differently…
Chris Mack
  • 5,148
  • 2
  • 12
  • 29
3
votes
1 answer

Loop through table and update a specific column

I have the following table: Id Category 1 some thing 2 value This table contains a lot of rows and what I'm trying to do is to update all the Category values to change every first letter to caps. For example, some thing should be Some…
User1899289003
  • 850
  • 2
  • 21
  • 40
3
votes
5 answers

Does Adding Indexes speed up String Wildcard % searches?

We are conducting a wildcard search on a database table with column string. Does creating a non-clustered index on columns help with wildcard searches? Will this improve performance? CREATE TABLE [dbo].[Product]( [ProductId] [int] NOT NULL, …
mattsmith5
  • 540
  • 4
  • 29
  • 67
3
votes
2 answers

Parse XML in SQL Server (with an array)

I'm trying to parse some XML in SQL Server, i've developed some code to do it but one of the data items returned come in the form of an array? SQL So far, with example XML... DECLARE @XML XML SET @XML = '
Micha
  • 81
  • 1
  • 8
3
votes
1 answer

memory mapped file write failed in SQL Server Replication

I am getting the error "memory mapped file write failed" while trying to run Snap Shot Agent in Transactional Replication. Snap shot works fine if the table is having only a few hundreds of rows. And fails if the table contains few thousands of…
Rahul Indian
  • 31
  • 2
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 Estiri
  • 76
  • 8
1
2
3
…
64 65