SQL Server 2022 - Development

• Topics

  Started by

  Posts

  Last post

• Question about Data Warehouse Management

  Hello SSC, Wishing everyone happiness and health and hope you are all doing well! I have a question…

  Lord Slaagh

  2 replies

  1 months, 3 weeks ago

  By: Lord Slaagh

• sp_prepare and sp_execute vs sp_executesql

  I have noticed sp_executesql also makes a single plan for a stmt with parameter in a loop. q1) Gene…

  rajemessage 14195

  2 replies

  1 months, 3 weeks ago

  By: Chandan Shukla

• Parameter sniffing issue with different minutes as opposed to using midnight

  Hej, I'm not facing this issue but as I was working another parameter sniffing issue I came to thin…

  mikael_ljunghorn

  5 replies

  1 months, 3 weeks ago

  By: mikael_ljunghorn

• XML_COMPRESSION for existing tables

  We are in the process of upgrading to SQL Server 2022 and would like to make use of the XML compres…

  zoggling

  2 replies

  2 months, 1 weeks ago

  By: zoggling

• Is there some good routines for updating SQL Server database objects with GitHub

  At work we've been getting better at writing what's known as GitHub Actions (workflows, YAML). I've…

  Rod at work

  3 replies

  2 months, 2 weeks ago

  By: Rod at work

• Rounding Off issue in SQL Server

  I am using Microsoft SQL Server 2022 (RTM-CU17) (KB5048038) - 16.0.4175.1 (X64)  Microsoft Corporat…

  vikramchander90

  5 replies

  2 months, 2 weeks ago

  By: pedro.costa

• taking the rcsi dive

  Hi, we put together an extract that runs every 15 minutes against what i believe is a homegrown som…

  stan

  4 replies

  2 months, 4 weeks ago

  By: Ken McKelvey

• Tracking changing prices and recalculating inventory value

  I'm trying to figure out a how to do average costing over time in T-SQL... I'll use up ingredient i…

  pietlinden

  6 replies

  3 months ago

  By: pietlinden

• having the right GIT (or whatever) for when i clone repos from devops

  Hi, i'm getting set up to begin using dev ops for source control over lots of dev types of objects …

  stan

  5 replies

  3 months, 1 weeks ago

  By: Mr. Brian Gale

• where did my topic on a new ssms 21 bug go

  Hi should i repost my latest ssms 21 bug, the one in which sql agent now doesnt show property detai…

  stan

  7 replies

  3 months, 1 weeks ago

  By: Steve Jones - SSC Editor

• ssms aborting in object explorer details

  Hi i just set up a new pc after my touch pad went bad.  our tech guy installed a version of ssms th…

  stan

  8 replies

  3 months, 2 weeks ago

  By: stan

• how does report builder play with dev ops

  Hi as i prepare for using source control, it occurs to me report builder is the most common way we …

  stan

  1 replies

  3 months, 3 weeks ago

  By: Mr. Brian Gale

• thought i installed ssis extension in vs2022 but got sql server database project

  Hi I dont think i'm crazy.   I had to get a new pc.   And reinstalling vs extensions unfortunately …

  stan

  3 replies

  3 months, 3 weeks ago

  By: stan

• Execution plan shows enormous number of records

  The problem was reported to us by a customer. They shared a graphic execution plan, fragment of whi…

  yerbabuena19

  6 replies

  3 months, 3 weeks ago

  By: mohdkaif002

• Please help to optimize the query

  Hi Experts, Thanks in advance. I am new to SQL. Can you please help me in optimizing the query? &nb…

  niteen2009

  3 replies

  3 months, 3 weeks ago

  By: VastSQL