SQL Server 2022 - Development

• Topics

  Started by

  Posts

  Last post

• Deleting data in large table

  I have a large table with 17M+ rows for our package record audits.  I've decided to clear out anyth…

  Jackie Lowery

  5 replies

  1 day, 23 hours ago

  By: Jackie Lowery

• Connecting ERP system E2 and Extract Data , perform Transformation

  Hello, May someone please help me how can I pull data from ERP named as E2. E2 is using SQL Server.…

  Rahulmsb5

  1 replies

  5 days ago

  By: Mr. Brian Gale

• SQL Newbie HELP: The query references an object that is not supported in distr..

  Hi everyone! I'm new to SQL and am trying to query a view (dbo.) made from a D365 table. My goal is…

  WBenning

  1 replies

  5 days, 5 hours ago

  By: Steve Jones - SSC Editor

• repeat results without loops, MSSQL2005 Express

  hello everybody, new here and this is my first question I have a table contains: Name, Id, joinDate…

  Sailor

  7 replies

  1 week, 2 days ago

  By: Sailor

• 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

  2 weeks ago

  By: mepestimation996

• 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

  2 weeks, 2 days 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

  2 weeks, 3 days ago

  By: Bolahitsitusslots

• ERD Tools recommendation

  Hey All, I'm looking for a free ERD tool. Does anyone have any recommendations? Thanks!

  Coffee_&_SQL

  5 replies

  2 weeks, 5 days ago

  By: Steve Jones - SSC Editor

• 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

  1 month 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

  1 month 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

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

  1 month, 2 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

  1 month, 3 weeks 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

  1 month, 4 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

  2 months ago

  By: Steve Jones - SSC Editor