SQL Server 2022 - Development

• Topics

  Started by

  Posts

  Last post

• 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

  6 replies

  2 days, 2 hours ago

  By: juniorDBA13

• 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 % …

  uratol

  3 replies

  5 days, 5 hours 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

  6 days, 2 hours 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

  1 week, 1 day 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

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

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

  sgraflund

  6 replies

  1 week, 4 days 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

  1 week, 6 days 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 weeks, 2 days 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 weeks, 5 days 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 weeks, 6 days ago

  By: EdVassie

• 2022 SSIS PackageFormatVersion?

  Recently I upgraded my ssis package from 2016 to 2022, but package format version is showing 8. Is …

  TG

  2 replies

  3 weeks, 1 day ago

  By: micherve

• Problem with the dll (version 1.2) of an Extended Stored Procedure with SQL Serv

  SQL Server 2022 16.0.4165.4 Windows Server 2022 Datacenter 21H2 20348.2849 Our Extended Stored Proc…

  SKEITA

  5 replies

  3 weeks, 4 days ago

  By: meghamala

• Parse XML data from SQL table using temp tables and variables

  Hello SSC, Happy Friday! I have to optimize a process that uses dynamic SQL to parse XML data. This…

  Lord Slaagh

  3 replies

  3 weeks, 6 days ago

  By: Eddie Wuerch

• XML data import with poor stored procedure performance (needs optimization)

  Hello SSC! I have been tasked with optimizing a stored procedure the imports data from XML to SQL t…

  Lord Slaagh

  3 replies

  1 month ago

  By: Lord Slaagh