SQL Server 2022 - Development

• Topics

  Started by

  Posts

  Last post

• Data Model for a framework to keep track of ETL processes

  Im attempting to come up with small framework or set of SQL tables that can be used to keep track o…

  GBeezy

  2 replies

  6 months, 1 weeks ago

  By: Mr. Brian Gale

• How to push PowerQuery results into SQL Server

  Sorry, me again. In my PowerQuery, I read a table out of a PDF file, do a bunch of transformations …

  pietlinden

  13 replies

  6 months, 2 weeks ago

  By: pietlinden

• Database growth

  Hi all I am currently using the following script to store database growth at clients. There are 2 i…

  Andre 425568

  2 replies

  6 months, 2 weeks ago

  By: Andre 425568

• How do I make this one row per id

  I've written this code, but it is showing right now as 2 rows per invg_id and there are alot of nul…

  ajillity81

  1 replies

  6 months, 3 weeks ago

  By: DesNorton

• 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

  6 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

  7 months, 1 weeks 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

  7 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

  7 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

  7 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

  7 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

  7 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

  8 months 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

  8 months, 1 weeks 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

  8 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

  8 months, 3 weeks ago

  By: uratol