SQL Server 2022 - Development

• Topics

  Started by

  Posts

  Last post

• Start SSMS Activity Monitor with Task State = (NonBlanks)

  I've been searching for this and cannot find any mention or discussion on it yet. So, I'll try here…

  s b dragoo

  1 replies

  1 year, 2 months ago

  By: Mr. Brian Gale

• Text column is taking More time while Querying, Need to Replace DATALENGTH

  select * from dbo.resolutions r where R.documentid = 828222222 and DATALENGTH(r.resolution_text) &g…

  ralahari

  18 replies

  1 year, 2 months ago

  By: ScottPletcher

• Strange(?) performance problems

  I am debugging an NHibernate generated SQL_query for performance problem and came up with something…

  oRBIT

  19 replies

  1 year, 2 months ago

  By: frederico_fonseca

• 2022 azure vm cant run same ssis pkg we run on prem

  Hi, we set up an environment on our new azure 2022 vm with a cloned  "prod target warehouse", ssis …

  stan

  20 replies

  1 year, 2 months ago

  By: stan

• SSIS package project connections don't work on upgrade

  We're upgrading from SQL Server 2016 to 2022.  The SSIS package project level connections don't wor…

  RonKyle

  1 replies

  1 year, 2 months ago

  By: Mr. Brian Gale

• More fun with Recursive CTEs

  Instead of dealing with courses this time, I'm trying to sort out how to model a recipe problem. (I…

  pietlinden

  8 replies

  1 year, 2 months ago

  By: pietlinden

• ssis 32 bit vs 64, debug and non debug

  Hi i am looking in vs2022 at my imported 2022 dev azure vm based ssis project.  And vs2022 at my 20…

  stan

  5 replies

  1 year, 2 months ago

  By: stan

• sql access with only local admin

  Hi we just stood up a vm in azure and one of our network guys installed most of the sql stack. He g…

  stan

  5 replies

  1 year, 2 months ago

  By: stan

• new vm in azure, where is ssisdb

  hi we just stood up an azure vm running 2022 developer and i see ssis is running.  it is for develo…

  stan

  3 replies

  1 year, 2 months ago

  By: Phil Parkin

• 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

  1 year, 2 months 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-reg…

  stan

  1 replies

  1 year, 2 months 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 n…

  stan

  4 replies

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

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

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

  1 year, 3 months ago

  By: Lord Slaagh