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
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
  • 1,045
  • 9
  • 17
3
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
  • 150
  • 2
  • 10
3
votes
3 answers

How to auto generate data types for a SQL table

I have many denormalize tables with 200+ columns. These tables are in SQL Server and they often, if not always, have varchar(100) or nvarchar(100) (string) data types. However, most columns are either ints, floats or other data types. It is not…
Shannon_Colt1999
  • 41
  • 3
3
votes
3 answers

SSRS - Unable to connect to datasource

Context: I have an installation of SQL Server 2019 installed on my local workstation and within an SSRS Report Project I'm trying to create a dataset that connects to this SQL Server datasource. I keep raising this error "Unable to connect to…
emalcolmb
  • 1,585
  • 4
  • 18
  • 43
3
votes
1 answer

How to make Spring boot post api Idempotent

I have created simple CRUD api using Spring Data JPA in my Spring boot application.My Post method in the controller looks like below:- @RequestMapping(value = "/article", method = RequestMethod.POST, produces = "application/json") public Article…
Manish
  • 1,274
  • 3
  • 22
  • 59
3
votes
1 answer

Return statement inside If condition does not work in SQL Functions

I have following function to convert string to int if convertible: CREATE FUNCTION dbo.[Dyve_FN_TryConvertInt](@Value varchar(18)) RETURNS int AS BEGIN SET @Value = REPLACE(@Value, ',', '') IF ISNUMERIC(@Value + 'e0') = 0 RETURN NULL IF…
Sunny Drall
  • 844
  • 9
  • 20
3
votes
2 answers

Error in @@ROWCOUNT inside SQL Server 2019 UDF

I found the @@ROWCOUNT when it is used inside a User Defined Function in MS SQL Server 2019 it doesn't work properly any more. I don't know if it's a MS SQL bug or a desired change of behavior. There is any option to go back to the behavior of 2019…
Alex
  • 797
  • 10
  • 30
3
votes
1 answer

SQL Server LEN function reports wrong result

Let's say we have the following casting of an int number into binary value i.e cast(120 as binary(8)) or any other int number into binary(8). What we normally expect from len(cast(120 as binary(8))) = 8 and this is true unless we try with number 32…
POLY
  • 31
  • 2
3
votes
1 answer

Import external table

I created an external table using polybase with CREATE EXTERNAL TABLE [ext].[gendertable] ( gender_id TINYINT NOT NULL, gender VARCHAR(16) NOT NULL ) WITH ( LOCATION = '/MovieDB/gender.csv', DATA_SOURCE = AzureBlobHDP,…
5th
  • 2,097
  • 3
  • 22
  • 41
2
votes
1 answer

Drop SSIS Proxy Credential

I am trying to drop a credential using this query: if exists (select * from sys.credentials where name = 'SSISProxyCredentials_ABC') drop credential SSISProxyCredentials_ABC But I am getting an error message saying: Msg 15541, Level 16, State…
Trying to be DBA
  • 25
  • 3
2
votes
2 answers

Using SqlDependency in .NET 7 and WinForms application

In my Winforms application I am trying to use SqlDependency so I created this data access class: internal class DataAccessLayer { private readonly SqlConnection sqlconnection; public DataAccessLayer() { sqlconnection = new…
M.Bouabdallah
  • 530
  • 10
  • 29
2
votes
2 answers

SQL Server: Transform arrays of JSON objects into table format

Following is the given JSON data: DECLARE @Jdata NVARCHAR(MAX) = '{ "EmployeeDetails": { "BusinessEntityID": 3, "NationalIDNumber": 509647174, "JobTitle": "Engineering Manager", "BirthDate": "1974-11-12", "MaritalStatus":…
MAK
  • 6,824
  • 25
  • 74
  • 131
2
votes
4 answers

Query to find difference between today and yesterday's data along with a pseudo column

There is a table that stores account data for everyday. I want to find out the difference in data between today and yesterday. The query for table creation and insert statements are below : CREATE TABLE daily_account_data (id varchar(6), Name…
Arty155
  • 103
  • 5
2
votes
0 answers

Setting Remote Query Timeout or Execution Timeout by user

Just want to find out if there is a way to set the "Remote Query Timeout" or "Execution Time out" for particular user, in SQL Server Context: our client wants access to a view in our database. therefore we are giving them their own connection…
Adhil
  • 1,678
  • 3
  • 20
  • 31
2
votes
0 answers

Merge Join Behaving differently when executed on Server and Local Machine. Outputs completely different

I have an SSIS package which has two source inputs sorted identically and with the same collation. The Merge Join is doing a full outer join. The two Queries in the source are as follows: SELECT [PolicyReference] ,[PolicyNarrativeReference] …
Michael Oakman
  • 31
  • 4
1 2
3
…
64 65