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
1 answer

Microsoft SQL Server equivalent of Oracle JSON_EQUAL

Oracle has a JSON_EQUAL function defined in the manual as: The JSON_EQUAL condition was introduced in Oracle 18c to allow JSON documents to be compared regardless of member order or document formatting. There seems to be no equivalent in Microsoft…
zu1b
  • 422
  • 5
  • 11
2
votes
1 answer

Appending a new array to a JSON object with SQL Server

I would like to append an array to a JSON object: JSON object: { "value1": "test" } Array to be appended: { "array2": ["1", "2", "3"] } Expected result: { "value1": "test", "array2": ["1", "2", "3"] } My attempts with JSON_MODIFY failed: Attempt…
janhase
  • 21
  • 2
2
votes
1 answer

BizTalk: Microsoft.Practises.ESB suspends messages on send port ALL.Exceptions with SQL-error

We are using the ESBExceptionDb in BizTalk 2020 to log error information. Recently, we have started go get the following error being suspended on application Microsoft.Practises.ESB on send port…
onmi
  • 87
  • 1
  • 9
2
votes
4 answers

Aggregate functions based on current Row value

I am working with data similar to below, week | product | sale 1 | ABC | 2 1 | ABC | 1 2 | ABC | 1 3 | ABC | 5 4 | ABC | 1 2 | DEF | 5 Let us say that is my Orders table named tblOrders. Now, in each…
jjk_charles
  • 1,250
  • 11
  • 23
2
votes
0 answers

How to get desired result with full-text search in SQL Server through thesaurus?

I am using SQL Server 2019. I define thesaurus in language XML in SQL Server full text search. 0 …
Samir Allahverdi
  • 71
  • 8
2
votes
1 answer

Check the execution time of a query accurate to the microsecond

I have a query in SQL Server 2019 that does a SELECT on the primary key fields of a table. This table has about 6 million rows of data in it. I want to know exactly how fast my query is down to the microsecond (or at least the 100 microsecond). …
andrewpw
  • 33
  • 6
2
votes
2 answers

SQL Server behaviour change while using datetimeoffset

I have been using SQL Server for quite sometime and noticed a change in behavior while using datetimeoffset. Lets take an example of two queries, one is using normal string comparison in datetime values and one which is using datetimeoffset type…
Ashu
  • 163
  • 4
  • 13
2
votes
2 answers

SQL Server : weird Invalid object name

I am trying to create a stored procedure and I get this error: Msg 208, Level 16, State 6, Procedure SP_MergeStagedPoliticalPartyAgents, Line 1 [Batch Start Line 0] Invalid object name 'SP_MergeStagedPoliticalPartyAgents'. SQL is as follows, minus…
Heinrich
  • 2,144
  • 3
  • 23
  • 39
2
votes
1 answer

SQL Server 2019 Polybase error - cant create External Data Source to SQL Server 2019

I am trying to setup an external data source in SQL Server 2019 to another database on the same server. I am doing this to replicate the SQL Azure setup currently running in production. I tried the following to set it up I installed SQL Server 2019…
Mohamed Cassim
  • 153
  • 1
  • 10
2
votes
0 answers

Microsoft SqlServer client TDS (reverse) proxy at the database catalog level

Does anyone know of software that can redirect a TDS client request to an appropriate instance of Sql Server based on the database catalog that the client is attempting to connect to? In other words, say I have 3 database catalogs (dbcat1, dbcat2,…
Granger
  • 3,639
  • 4
  • 36
  • 34
2
votes
2 answers

Attempted to perform an unauthorized operation when executing SQL Server 2019 service pack

I already had SQL Server 2019. After upgrading my Windows 10 to latest October Update, I found my SQL Server does not have latest service packs. I downloaded latest service pack CU8 from Microsoft and ran it. After initializing set up, I get…
FLICKER
  • 6,439
  • 4
  • 45
  • 75
2
votes
3 answers

SQL - Splitting string in multiple columns

I'd like to split the result from a query and display the values in separate columns. As an example I get the following result |Name | |ABC_DEFG_HIJKL| |A_B_C | |A_B_C_D | I want to split the values by '_' and add them to…
riflex
  • 83
  • 1
  • 9
2
votes
1 answer

SQL Server Graph: how identify subgraphs?

I have [Friends] node and [Link] edge. My task is to figure-out which friend to which subgraph(network) belongs. Simple illustration of this: Here is my code how I construct nodes, edges and populate the data: -- Construct nodes DROP TABLE IF…
Juozas
  • 916
  • 10
  • 17
2
votes
3 answers

SQL Install Error: The MOF compiler could not connect with the WMI server

I needed to move (some of) my sql install from C: to D: because of space. SQL installer insists some of it stay on C:. Then I needed (decided) to reinstall it, but sql would not do the reinstall. Gave me error: MOF compiler could not connect…
kennr
  • 49
  • 1
  • 1
  • 6
2
votes
2 answers

K8s SQL2019 HA Containers - Dude, where are my Pods?

New to K8s. So far I have the following: docker-ce-19.03.8 docker-ce-cli-19.03.8 containerd.io-1.2.13 kubelet-1.18.5 kubeadm-1.18.5 kubectl-1.18.5 etcd-3.4.10 Use Flannel for Pod Overlay Net Performed all of the host-level work (SELinux…
thepip3r
  • 2,855
  • 6
  • 32
  • 38
1 2 3
…
64 65