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

SQL Server 2019 ignoring WHERE clause?

I'm getting an error when I try to run a simple aggregating query. SELECT MAX(CAST(someDate as datetime)) AS MAX_DT FROM #SomeTable WHERE ISDATE(someDate) = 1 ERROR: Conversion failed when converting date and/or time from character string. Non-date…
FmlyMaan
  • 31
  • 2
2
votes
1 answer

SQL Server sort data with Order By according to current date

I have a table WebOrder Below is a simplified version of the table (I omitted most of the columns that weren't necessary for this post) +-------------------+----------------+ |Field |Type …
Chase T
  • 47
  • 5
2
votes
2 answers

SQL scalar function msg 107 after upgrade to 2019

I have a really simple scalar function with the following code: SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER FUNCTION [dbo].[GetNDate_YYYYMM] ( @InputDate DATETIME ) RETURNS INT AS BEGIN DECLARE @RIS AS INT SET @RIS=NULL …
James
  • 373
  • 4
  • 14
2
votes
0 answers

Do sqlcmd and SSMS not validate the server certificate if the server enforces the encryption?

I am hosting a few linux SQL Server 2019 instances. All connections to these instances should be encrypted, and therefore I enforce the encryption on the server side like this (following the official instructions here): /opt/mssql/bin/mssql-conf set…
MrWolfZ
  • 388
  • 3
  • 8
2
votes
1 answer

Nothing provides python needed by mssql-server-is

I'm trying to install SQL Server Integration Services on RHEL 8. I have SQL Server 2019 (version v15) installed and running successfully, but when I try and follow…
Hayward
  • 21
  • 5
2
votes
1 answer

Cannot connect to SQL Server 2019 using new MSOLEDBSQL

I am converting my application to use MSOLEDBSQL from SQL Server Native Client 11.0 I have changed my connection string from "Driver={SQL Server Native Client 11.0}" to "Provider=MSOLEDBSQL" along with UID,PWD,Server,Database parameters. But I could…
Ash
  • 809
  • 1
  • 8
  • 14
2
votes
1 answer

Why is External Table syntax different in SQL Server 2019 vs Azure SQL Database? `

I have to perform cross DB querying in SQL Server 2019 as well as Azure SQL. I am able to create External data source and external tables in both databases, however the syntax seem to be different. Can someone please guide me if there is one…
Shubham Garg
  • 21
  • 1
2
votes
0 answers

"Internal connection fatal error" from TdsParser when calling native compiled stored procedure in SQL Server 2019

I am having huge problems with the current SQL Server 2019 (15.0.2070.41) and native compiled stored procedures when calling them from the Microsoft.Data.SqlClient (1.1.0 and lower). It is working when either using SQL Server 2017 or…
Juri Robl
  • 5,614
  • 2
  • 29
  • 46
2
votes
1 answer

SQL Server 2019 Master Data Services Filtering on Numeric

I have recently upgraded a MDS 2017 instance to 2019. After the update, users are experiencing an error when trying to filter on a Number Type Attribute within an Entity view on the web interface. I can find no reported instances of this online. …
Doug Olson
  • 21
  • 1
2
votes
2 answers

How to determine if given table is memory optimized?

Good morning, My first question is how to determine if tables created in MS SQL Server are memory optimized. I have some tables and I don't remember if some of them I created in-memory optimized or not. Many thanks for answers.
Piotr Wojcik
  • 23
  • 3
2
votes
0 answers

How to log using SQL Server Java Language Extension?

I have a Java program that is executed by SQL Server using SQL Server's Java language extension. The Java program logs output to a file using logback. Here's my logback.xml config:
James
  • 2,876
  • 18
  • 72
  • 116
2
votes
1 answer

SqlServer On Kubernetes Cluster not able to deploy

Im trying to deploy a SQLServer Always on into a kubernetes cluster on premise with bases os ubuntu server 19 latest patch Here is Setup Kubeadm v1.16.0 Docker 18.09.7 Nodes NAME STATUS ROLES AGE VERSION master-node Ready …
Ricardo Granados
  • 21
  • 3
2
votes
1 answer

How to fix 'pod has unbound immediate PersistentVolumeClaims' in SQL 2019 Big Data?

I want to set up simple persistent storage on Kubernetes for SQL 2019 Big Data on prem. But keeps throwing an event 'pod has unbound immediate PersistentVolumeClaims'. When I deploy the image, pod mssql-controller shows an event: Name: …
Nejc
  • 21
  • 1
  • 2
1
vote
1 answer

Is 100 a magic number for cardinality estimation of SELECT * FROM [Multi-Statement-Table-Valued-Function] queries?

I'm running on SQL Server 2019. Whenever I write a query of the form SELECT * FROM [Multi-Statement-Table-Valued-Function] the execution plan shows that it expected to get 100 rows from this process. Is this a consistent and documented pattern? Or…
J. Mini
  • 1,868
  • 1
  • 9
  • 38
1
vote
1 answer

SQL Query to return member count with a membership start date and end date by Month

We would like to get a monthly count of the number of members who have a type of benefit by Month. If the end date for a member and benefit is last month then the active_b_count would decreased by 1 and similarly if the start date for the member and…
Paul
  • 1,103
  • 1
  • 13
  • 18
1 2 3
…
64 65