SQL Server 2022 is a release name of the Microsoft SQL Server 16.0 released on November 16, 2022. Use this tag only for questions about SQL Server 2022 specific questions. For generic questions about SQL, T-SQL, or Microsoft SQL Server, please use tags [sql], [tsql], and [sql-server] instead.
Questions tagged [sql-server-2022]
60 questions
0
votes
0 answers
How to limit SQL Server Developer edition to Standard features
I use
Developer edition in my dev environment
Standard edition in production
I want to make sure that in my dev env, indexed views will be treated the same way as in production.
Can I setup the Developer Edition to behave like…
Liero
- 25,216
- 29
- 151
- 297
0
votes
1 answer
The option 'hadoop connectivity' cannot be enabled in this edition of SQL Server
I'm trying to run polybase in SQL Server 2022.
When running EXEC sp_configure @configname = 'hadoop connectivity', @configvalue = 7;
I get the error
Msg 46934, Level 16, State 1, Procedure sp_configure, Line 177 [Batch Start Line 4]
The option…
Neil P
- 2,920
- 5
- 33
- 64
0
votes
0 answers
Cannot find the CREDENTIAL ... because it does not exist or you do not have permission
I follow the instructions on https://learn.microsoft.com/en-us/sql/relational-databases/polybase/polybase-configure-s3-compatible?view=sql-server-ver16 to access files on an S3 bucket (running on MinIo) from SQL Server 2022. However I run into the…
nojetlag
- 753
- 2
- 14
- 27
0
votes
1 answer
Exception during db mirroring failover to SQL Server 2022 from previous version
To perform upgrade of production DB cluster from the current SQL Server 2014 to the new SQL Server 2022 without downtime, I use DB Mirroring approach:
Primary node - SQL Server 2014 Std (v12.0.6439.10, Build 9600)
Secondary node - SQL Server 2022…
Anton S
- 21
- 2
0
votes
1 answer
Logic App failing to select rows from SQL Server Table with multiple dots in schema name
I'm having a logic app that is trying to Get Rows (V2) from On Premise SQL Server. The SQL Server schemna name is having multiple dots in it. The SQL Server table name is [vehicle.small.fourwheel.car.kia].[Picanto], where…
Aritra Sarkar
- 225
- 4
- 13
0
votes
1 answer
Creating permutations of the column based on same column value Sql
I am trying to create a cross join in order to get this result. The goal is to get permutations of a column based on a same value in the same table . This is the input…
RR8422
- 3
- 3
0
votes
1 answer
In SQL Server 2022, why is `IS [NOT] NULL` converted to `IS [NOT] DISTINCT FROM NULL` in CHECK and filtered indexes? Is it safe?
As a foreword, I am already familiar with the differences between the IS \[NOT\] NULL and IS \[NOT\] DISTINCT FROM NULL predicates.
So to be clear, I am not asking what IS DISTINCT FROM NULL does, nor how it differs from other types of…
Dai
- 141,631
- 28
- 261
- 374
-1
votes
0 answers
reportviewer "request failed with an empty response" for reportViewer.ServerReport.SetParameters to SSRS 2022
We are receiving an error when trying to render a report in our web application using the Microsoft.Reporting.WebForms. The same code works on older version on Reporting services on SQL 2014. While we are receving error when trying with the latest…
ManuSQLGeek
- 29
- 3
-1
votes
0 answers
SQL Server 2022 when a deadlock occurs does not choose a victim
I am running into a problem, when a deadlock occurs, SQL Server 2022 does not choose a victim.
I am using a previous post for the code (How to simulate DEADLOCK on SQL Server?) to create the deadlock condition, but SQL Server 2022 does not choose a…
-1
votes
2 answers
How can I run calculations on batches of entries in a table based on other columns?
I have a SQL table that looks kind of like the following
entry_ID type_of_entry time_of_entry
1 0 12:00
2 0 12:05
3 1 12:15
4 0 15:14
5 1 …
Eric
- 3
- 2
-1
votes
1 answer
How to remove duplicate values from datatable SQL
Getting values duplicate:
╔══════╦══════╦═══════╦════════════╦═════════╦═════════╦══════╦═══════╗
║ ID ║ Name ║ Class ║ Date ║ Intime ║ Outtime ║ INAM ║ OUTPM ║
╠══════╬══════╬═══════╬════════════╬═════════╬═════════╬══════╬═══════╣
║ 1001…
bush
- 11
- 3
-2
votes
1 answer
Update Parent Status depending on Childs Status
I have a hierarchical structure of my data.
Each record has a status column. If this is set, I want to inherit this upwards.
I tried using CTE to recursively determine the smallest status of the respective childs. If not all children have status 1,…
forGG
- 9
-3
votes
1 answer
TSQL Merge Slow After First Success Index Issue?
Using MSSQL 2022.
Source temp table has 156,289 rows. Destination table has zero rows. Use case is to insert rows from temp->destination where rows do not already exist in destination. 4 columns determine if a row is unique.
Using Merge When Not…
Snowy
- 5,942
- 19
- 65
- 119