SQL Server 2022 - Development

• Topics

  Started by

  Posts

  Last post

• Removing Filestream - How?

  Hello, we are migrating our SQL Server database and one of the tasks is to stop using Filestream.  …

  amy26

  29 replies

  1 year ago

  By: Perry Whittle

• Case Statement Optimization

  CASE WHEN ( Table1.Column IN (@Parameter1) OR b.cat3 = 1 OR (Table1.Column='XXXX' AND SV.Column IN …

  ralahari

  1 replies

  1 year ago

  By: drew.allen

• Sub Queries Optimization

  (SELECT Column1 FROM Table1) as --5 Table1_1 ON table3.Column1  = Table1_1.Column1 LEFT JOIN (SELEC…

  ralahari

  2 replies

  1 year ago

  By: drew.allen

• how to assign studentid from one table to other one? please

  Good Morning,   how to assign query one results to query 2 student id, each record should have…

  Zond Sita

  8 replies

  1 year ago

  By: ScottPletcher

• Upgrade to SQL2019 from 2012 Query is taking time, Need Query Optimization steps

  Upgrade to SQL2019 from 2012 Query is taking time, Need Query Optimization steps and Pre requisites…

  ralahari

  4 replies

  1 year ago

  By: Jonathan AC Roberts

• What happened to my SSMS shortcuts in 20.1?

  I installed SSMS 20.1 and all my trusted keyboard shortcuts don't work anymore... <Ctrl>E --&…

  Eric Mamet

  4 replies

  1 year ago

  By: Eric Mamet

• Using USE does not set DB context

  Hi Experts, I have a Sql file with a bunch of DDL statements (Create Tables/Views). I start with a …

  belal360

  9 replies

  1 year ago

  By: Jonathan AC Roberts

• blocking due to cuncurrency problem.

  hi, CREATE TABLE [dbo].[bridge]( bridgeid [bigint] NOT NULL, [idpool] bigint NULL, status int null …

  rajemessage 14195

  14 replies

  1 year ago

  By: Jonathan AC Roberts

• JSON escape characters

  Hello, I'm tasked to generate JSON files with the FOR JSON Clause of SQL Server Is there an easy wa…

  Jo Pattyn

  8 replies

  1 year ago

  By: frederico_fonseca

• Querystore bug(?), not showing data

  My company where I worked recently upgraded to SQL Server 2022 Enterprise and Querystore started to…

  oRBIT

  3 replies

  1 year ago

  By: oRBIT

• singleton is interferring with getting multiple nodes in xml

  Hi we have an xml doc shaped essentially as shown in image 2 below.   Unfortunately we are so used …

  stan

  8 replies

  1 year ago

  By: Jonathan AC Roberts

• Calculating moving moving averages for different ranges in one query

  I have this query, which is gives result I want (may be not, i have not checked extensively yet), i…

  Sezam

  5 replies

  1 year ago

  By: Sezam

• I have few snapshot transactions, now i need to put noloc in all tables.

  I have few snapshot transactions , now my admin has informed me that put no lock in all tables in s…

  rajemessage 14195

  6 replies

  1 year ago

  By: Eirikur Eiriksson

• SSIS Connecting to Azure SQL Managed Instance w/ MFA

  We've been testing out Azure SQL Managed Instance and created SSIS packages to run against it. We s…

  tjcavins

  1 replies

  1 year, 1 month ago

  By: Perry Whittle

• Inserting 100K rows Performance - Baseline Performance

  We're trying to understand how quick new versions of SQL server can be.  Obviously server specs com…

  MichaelT

  11 replies

  1 year, 1 month ago

  By: frederico_fonseca