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
2
votes
0 answers

SSIS Custom Connection Manager

I`m trying to create a custom connection manager for SQL Server Integration Services 2019, this component already works in SQL Server Integration Services 2012, but, after converting to SQL Server 2019 and changing DLLs of the same version, when I…
user11890
  • 170
  • 5
2
votes
0 answers

How to change or avoid default value in SQL-Profiler call? | SQL Profiler | SQL Server

How to change or avoid default value in SQL-Profiler call? SQL Server 2019/2017 Profiler set default values for all parameters of a stored procedure. however, It's additional and gives errors in execution. therefore, I have to remove default value…
Haseeb
  • 746
  • 7
  • 22
2
votes
1 answer

Handling null decimal values in ASP.NET Core 6 MVC model

I have a model in my ASP.NET Core 6 MVC data context that accepts a certain decimal value, myNullableDecimal. This value needs to be nullable, since "0.00" would be interpreted downstream as a valid, or non-null, response. So, I set the…
bmurrell30
  • 565
  • 8
  • 23
2
votes
1 answer

Old SQL function using @@ROWCOUNT causing issues

We have a SQL function which was written years ago that has been causing sporadic issues (for years I think). I was finally able to get my hands on a backup of a customers DB so that I could figure out what is going on. The function in question…
WBuck
  • 5,162
  • 2
  • 25
  • 36
2
votes
0 answers

'OPENJSON' is not a recognized built-in function name

I'm using Microsoft SQL Server 2019 - 15.0.4236.7 (X64) Compatibility Level is 2019 \ 150 I have a very simple query to transpose some JSON that is stored in a column: SELECT OPENJSON ([fieldname]) FROM mytable But I keep recieing the…
Michael
  • 2,507
  • 8
  • 35
  • 71
2
votes
1 answer

How to sign a SQL Server assembly created with assembly_bits / hex bytes?

I'm working on an upgrade to SQL Server 2019 and I need to sign assemblies. However, the assembly code I have is using assembly_bits / hex bytes. I cannot find a good way to sign this assembly. How can this assembly be signed? Below is a non-working…
Russ960
  • 1,109
  • 2
  • 17
  • 33
2
votes
2 answers

Replacing a string over multiple rows

I have a table like this one: ID Code CodeType CodeExt 1 -S_P&S_A S_P A+B 1 -S_P&S_A S_A C 2 S_P/S_A/S_Z S_P A+B+C 2 S_P/S_A/S_Z S_A D 2 S_P/S_A/S_Z S_Z E 3 S_P S_P A The expected output…
jigga
  • 558
  • 4
  • 16
2
votes
2 answers

ERROR: Unsupported PIVOT column type: text

I'm trying to perform a PIVOT but getting an error. I'm trying to see which patients have more than one Interval session. The column is a text type. I attempted to convert the column type to VARCHAR(MAX) in my query but still getting the error. Here…
Daniel Gomez
  • 23
  • 5
2
votes
1 answer

Create groups based on 14 day interval

I know this is a common question, but I couldn't find something that matches my case. I have this data: +---------+---------+ | user_id | view_dt | +---------+---------+ | A | 1/1 | +---------+---------+ | A | 1/10…
daniellerobinson7836
  • 27
  • 3
2
votes
0 answers

how to compute a hash in C# with the correct coding?

when I get a hash from C# I seem to get a different value then when I do it in sql server. Take this query declare @test table (value nvarchar(100)) insert into @test values ('1234'), (N'1234') select 'from db' as source, t.value,…
GuidoG
  • 11,359
  • 6
  • 44
  • 79
2
votes
2 answers

The current transaction attempted to update a record that has been updated since this transaction started. The transaction was aborted

I'm trying to update a table which is In-Memory OLTP. There is a scenario where we may have to update a same row in parallel. During concurrent update of a same record I am getting below reported error. Here is my sample update statement. In SQL…
Guna
  • 113
  • 3
  • 9
2
votes
1 answer

How to import flat file with duplicate primary key records into SQL table

I have a SQL table with Case_id as a primary key. I'm using Visual Studio SSIS to import flat files into the table and a Task Factory Upsert destination component to handle the insert/update part. The source file also has a column for the update…
Don
  • 78
  • 5
2
votes
1 answer

Why does it give an error when deserializing the plot?

The problem is as follows. A matplotlib plot is created by MSSQL2019 sp_execute_external_script(the code is at the end of the post), after that the plot is serialized as the byte sequence and sent to Python script. Then at the stage of graph back…
Snoubort
  • 21
  • 3
2
votes
4 answers

What do indexed views actually index

As I understand it SQL views represent 'a virtual table' where the data is actually held in other 'backing tables' the view references. Indexes can be added to views to improve performance, but what do these indexes actually reference if the view is…
andrew pate
  • 3,833
  • 36
  • 28
2
votes
1 answer

Group By clause not working correctly with sp_executesql

sp_executesql is not working correctly with the group by clause and, I am debugging this. I stripped out all parameters from sp_executesql, and have this simple batch: declare @SQLStatement nvarchar(1000); set @SQLStatement='select…
Vikram Singh
  • 435
  • 2
  • 10
1 2 3
…
64 65