SQL Server 2022 - Development

• Topics

  Started by

  Posts

  Last post

• Arithmetic overflow error converting IDENTITY to data type bigint

  Hello SQL experts, I have a legacy application developed when SQL server did not have native suppor…

  narwhale

  12 replies

  9 months, 1 week ago

  By: ScottPletcher

• reinstall of vs2022 and core tools leaves me short of ssis output/input comps

  Hi.   You can see at https://www.sqlservercentral.com/forums/topic/how-can-vs-see-ssis-under-my-r…

  stan

  1 replies

  9 months, 1 week ago

  By: stan

• how can vs see SSIS under my regular user id but not my admin?

  Hi, we run vs 2022.   I'm stumped how when i run VS as admin i cant see ssis after hitting create…

  stan

  4 replies

  9 months, 1 week ago

  By: stan

• Index Update Reports - Scans/Seeks

  SELECT DB_Name() As CurrentDatabase, objects.name AS Table_name, indexes.name AS Index_name, SUM(dm…

  JKSQL

  3 replies

  9 months, 1 week ago

  By: Jeff Moden

• Query timeout question

  I am debugging (sort of) a problematic query, that gives a timeout error (30 seconds) in our compan…

  oRBIT

  5 replies

  9 months, 2 weeks ago

  By: Jeff Moden

• SSIS Visual Studio 2022: Trying to avoid linked servers using SSIS

  Hello SSC! First, I would like to thank everyone for their assistance with my posts. You folks are …

  Lord Slaagh

  5 replies

  9 months, 3 weeks ago

  By: Lord Slaagh

• Code does Not Read in FY 2025 Data

  Please Only assist, if you want to. I don't need the negativity from the regulars who troll this fo…

  yrstruly

  20 replies

  10 months ago

  By: deubel_m

• Dark mode, other color schemes

  All, if you are like me and do not care for the built-in color schemes, try http://www.sqlshades.co…

  mjdemaris

  1 replies

  10 months ago

  By: mjdemaris

• Issues adding and updating a column

  Hi all   I'm hoping someone will able to say "you're an idiot because....." on this one.  …

  richardmgreen1

  4 replies

  10 months, 1 week ago

  By: richardmgreen1

• SSIS execute powershell fails with exit code 1

  I'm trying to execute a simple, test powershell script (which works fine when I right-click it and …

  isaac_654135

  5 replies

  10 months, 1 week ago

  By: Mr. Brian Gale

• Calendar & Fiscal Year Table

  I have a Calendar table that need to be displaying Fiscal Start and End Date as in below: The Cale…

  yrstruly

  4 replies

  10 months, 1 week ago

  By: Ed B

• TSQL Help, Possible a recursive CTE

  Hi I have 2 tables Table A JoiningID, MainID 1010619, 646703 991840, 238649 991840, 577578 991840, …

  erics44

  17 replies

  10 months, 2 weeks ago

  By: erics44

• Updated Table Not Displaying Data

  I have a table that contains data only to Financial Year/FY 2024: CREATE TABLE [Prod].[IMETA - Cale…

  yrstruly

  8 replies

  10 months, 2 weeks ago

  By: Jeff Moden

• scalar function "select" permission issue when Grant has been applied "execute"

  I have a scalar function used on a sql server 2016. I have created a database role using the user l…

  graham.measures

  5 replies

  10 months, 2 weeks ago

  By: christophe.vanolmen

• SSRS report Query Optimization

  How to optimize below Query, Could you Please guide me.   SELECT       selected_sfs.sfName…

  ralahari

  7 replies

  10 months, 3 weeks ago

  By: Phil Parkin