SQL Server 2022 - Development

• Topics

  Started by

  Posts

  Last post

• Database Query Optimization: How to Improve Query Performance in SQL

  I have a SQL database that stores a large amount of data, and I'm experiencing slow query performan…

  Piyushbhatt

  6 replies

  2 weeks, 5 days ago

  By: ScottPletcher

• Get the change record details with flag

  ---Incoming data everytime Drop table if exists #Temp Create table #Temp (Col1 Nvarchar(1000), Co…

  LearnSQL

  8 replies

  3 weeks ago

  By: LearnSQL

• Only getting few records into destination table

    Please assist. The code is Postgres, but the principle remains the same i believe. I am retr…

  yrstruly

  6 replies

  3 weeks, 3 days ago

  By: yrstruly

• Multicolumn indexes and fragmentation

  Is there anything special you should think of concerning index fragmentation and multicolumn indexe…

  oRBIT

  11 replies

  3 weeks, 5 days ago

  By: Jeff Moden

• Is it possible? Allocate Identity values before performing insert

  I have a process that generates a batch of documents. In these documents it would be 'nice' to embe…

  aztec_2step

  16 replies

  1 month ago

  By: kajaldigital8700@gmail.com

• User does not have access to reports

  Hello, I would like advice on how to allow users to open reports.  So far, we have the home folder…

  mjdemaris

  5 replies

  1 month ago

  By: mjdemaris

• SQL2022 UPDATED FROM SQL2014 - PARALLELISM ISSUES

  Hi We just updated from SQL2014 to SQL2022. Most everything went fairly well - except I have about …

  krypto69

  6 replies

  1 month ago

  By: Jeff Moden

• Running 32 bit SSIS package

  This is my first post in this forum, so hello everyone! Would be most grateful for help with the fo…

  IgorSharpay

  10 replies

  1 month ago

  By: IgorSharpay

• Determine if value occurred within all shifts

  I have an employee table with job Start and End dates. I also have a shift table of all available s…

  boehnc

  9 replies

  1 month ago

  By: Jeff Moden

• Need Assistance- 32-bit SSIS Package and Analyzing Shift-wise Data

  I'm currently working with SQL Server 2022 - Development edition and I'm facing a couple of challen…

  katherine_ryan

  2 replies

  1 month ago

  By: pietlinden

• How to get max date for each column in SQL Server

  Hello All, I have a table where I am having data like below. Here my requirement is I need to get t…

  Krish319

  9 replies

  1 month, 1 week ago

  By: ScottPletcher

• Performance related issue in the report after adding new table in the sp .

  I have an issue in the report. Have added new table in the SP. After adding new table report render…

  Smash125

  4 replies

  1 month, 1 week ago

  By: Jeff Moden

• how new window clause works in following case.

  hi, can i get one example of following from this link https://learn.microsoft.com/en-us/sql/t-sql/q…

  rajemessage 14195

  1 replies

  1 month, 2 weeks ago

  By: Steve Jones - SSC Editor

• Proc and Table permissions (Grantor column)

  I have several tables and stored procedures that have an user ID of a person that is no longer with…

  DotNetCoder

  1 replies

  1 month, 2 weeks ago

  By: Phil Parkin

• How to remove dulpicates caused by other columns?

    Hi everyone, Newbie here. How to remove duplicates caused by DateFrom and DateTo columns? I …

  majime

  3 replies

  1 month, 2 weeks ago

  By: Jonathan AC Roberts