SQL Server 2022 - Development

• Topics

  Started by

  Posts

  Last post

• T-SQL to SELECT rows where 2 columns in TBL_A do not exist in TBL_B

  I have 2 tables: TBL_A and TBL_B each with the same 2 columns; ServerName nvarchar(50) and LoginNam…

  Express12

  2 replies

  8 months, 3 weeks ago

  By: Express12

• Dependency Chain

  I have not yet been able to come up with a tidy solution for this one. An ETL process I've built ha…

  Phil Parkin

  10 replies

  9 months ago

  By: Mr. Brian Gale

• Better way to set order of selections/precedence order?

  Our application sells products from various distributors. Each buyer has a "precedence order" when …

  hoa.nguyen 64423

  3 replies

  9 months, 1 weeks ago

  By: Phil Parkin

• SQL - Conditional merge join

  I want to add a condition in the joining columns part of the merge statement like this : Merge dbo.…

  SQL Bee

  1 replies

  9 months, 3 weeks ago

  By: ratbak

• OpenQuery with Application Intent specified runs on primary node.

  I have an Open query that runs on an Always On server via a linked server and does selects * only. …

  kailash.kanaya

  2 replies

  9 months, 3 weeks ago

  By: kailash.kanaya

• average duration increasing inline with exec counts

  As the title says , I've got a handful of stored procs where the avg duration rises and falls prett…

  simon_s

  3 replies

  9 months, 3 weeks ago

  By: Jeff Moden

• How do I add all the values in the column considering it to be in hh:mm:ss:ms

  How do I add all the values in the column considering it to be in hh:mm:ss:ms Please help.  

  satnam.singh 44358

  6 replies

  9 months, 3 weeks ago

  By: Jeff Moden

• Calculating Difference between Multiple Dates for a Given Condition in HH:MM:SS

  We have the following requirement:- Event_Time                                                actio…

  satnam.singh 44358

  3 replies

  9 months, 4 weeks ago

  By: satnam.singh 44358

• High Availability Reversed - Force secondary unless failure

  Hi I have sql2022 in H/A with a primary and a secondary server. My problem is that I have a query t…

  krypto69

  1 replies

  10 months ago

  By: Jeffrey Williams

• Remove ISNULL FROM left join to make SARGAble

  Hi, I'm trying to make the below query SARGable by removing the ISNULL function part of the join. (…

  juniorDBA13

  7 replies

  10 months, 1 weeks ago

  By: Jo Pattyn

• New lightweight pure‑T‑SQL unit‑testing framework (T‑TEST) — feedback welcome

    Hi all, I’ve just open‑sourced T‑TEST, a tiny alternative to tSQLt that lives 100 % in T‑SQL…

  uratol

  3 replies

  10 months, 2 weeks ago

  By: uratol

• SQL Query Performance with Left Join

  I have a query that is performing poorly It has a left join to a table with 2 conditions, the query…

  juniorDBA13

  9 replies

  10 months, 3 weeks ago

  By: juniorDBA13

• CAST(VARCHAR(n)) resolved performance issue?

  Hi, I would love to hear if anyone can tell me why a CAST in a query can "resolve" this performance…

  mikael_ljunghorn

  2 replies

  10 months, 3 weeks ago

  By: mikael_ljunghorn

• varbinary column making select longer

  Have a table with varbinary(8000) column. When carrying out a select and including this column the …

  juniorDBA13

  12 replies

  10 months, 3 weeks ago

  By: Jeff Moden

• Merge data from two different source until the data is available from both sourc

  I have two sources , one coming from datalake and another is file. we need to match date to combine…

  komal145

  2 replies

  10 months, 3 weeks ago

  By: MMartin1