SQL Server 2022 - Development

• Topics

  Started by

  Posts

  Last post

• 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

  8 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

  8 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

  8 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

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

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

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

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

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

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

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

  9 months, 1 weeks ago

  By: SKEITA

• 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

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

  9 months, 2 weeks ago

  By: Lord Slaagh

• Refactoring a DELETE query using NOT EXISTS — need expert feedback

  Hi everyone, I'm working on optimizing a DELETE query used in a data cleanup process, and I’d like …

  abdalah.mehdoini

  1 replies

  9 months, 3 weeks ago

  By: abdalah.mehdoini

• Need help with Cut off time in SQL

  Hi - Currently, I have this DAX coded in Power BI Ticket Cutoff Status = VAR TimeOnly = TIME(HOUR([…

  hollyanneu2

  2 replies

  9 months, 3 weeks ago

  By: WirkKarl