SQL Server 2022 - Development

• Topics

  Started by

  Posts

  Last post

• 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

  1 month, 2 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

  1 month, 2 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

  1 month, 3 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

  1 month, 4 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

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

  2 months, 1 week 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

  2 months, 1 week 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

  2 months, 2 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

  2 months, 2 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

  2 months, 2 weeks ago

  By: MMartin1

• SSIS how to manage source control with multiple packages / projects

  We've got upwards of 40 SSIS solutions all stored in one GIT repository in teams.  I thought this w…

  sgraflund

  6 replies

  2 months, 2 weeks ago

  By: trulycouncil

• Migrating data from using ManagerId to HierarchyId

  I have a table called Person with the following schema: CREATE TABLE [People].[Person]( [Id] [sm…

  edwardwill

  10 replies

  2 months, 2 weeks ago

  By: edwardwill

• Parse SQL XML column into dynamic temp tables

  Hello SSC, I hope everyone is happy and healthy and ready for spring! I am looking for some alterna…

  Lord Slaagh

  2 replies

  2 months, 3 weeks ago

  By: Lord Slaagh

• ERROR: The requested OLE DB Provider Microsoft.ACE.OLEDB.16.0 is not registered

  Using VS2019 editor -- developing SSIS Pkg to ingest an Excel XLSX v16.03 file and LOAD into a SQL …

  Express12

  5 replies

  2 months, 3 weeks ago

  By: Jeff Moden

• Internationalisation

  Quick one I hope in case I'm heading off in entirely the wrong direction! I've been working on a pr…

  julian.fletcher

  6 replies

  2 months, 3 weeks ago

  By: EdVassie