SQL Server 2022 - Development

• Topics

  Started by

  Posts

  Last post

• table with varcahar(max)

  Gurus, there is a table which is very slow to query , it has only 3 months data, logid is PK, index…

  sqlguy80

  6 replies

  29 minutes ago

  By: sqlguy80

• Migration from Sybase SAP SQL Anywhere to SQL Server 2022

  We are working on a project to migrate a client from a version of SAP Sql Anywhere (Sybase) to SQL …

  Stewart "Arturius" Campbell

  2 replies

  10 hours, 37 minutes ago

  By: frederico_fonseca

• Interview Questions for Advanced DB Engineer Candidates

  Many years ago, a recruiter called me about a job, and the company had given her a list of seven sc…

  David Moutray

  8 replies

  1 day, 2 hours ago

  By: Jeff Moden

• Coding Questions for Advanced DB Developer Candidates

  I was recently re-reading an old article on conducting programming interviews, when I came across t…

  David Moutray

  11 replies

  1 day, 21 hours ago

  By: David Moutray

• Can find the issue for join that does not work

  I am trying to join these two tables using Left Join (POSTGRES, believe TSQL is the same principle)…

  yrstruly

  27 replies

  3 days, 7 hours ago

  By: yrstruly

• Searching in date field provides inconsistent results

  I have been working with SQL Server for too many years to count and this is baffling; perhaps someo…

  Ed Thompson

  9 replies

  4 days, 3 hours ago

  By: jcelko212 32090

• Both values between Start and End date

  good afternoon, I'm trying to determine if both values (101 and 102) both occur within a 'Shift' (s…

  boehnc

  1 replies

  1 week, 1 day ago

  By: ScottPletcher

• SSIS Event Handler (OnError) Fires even with no error.

  I have a SSIS package and set Event Handler (OnError) to send me a message with logs: "Package: " +…

  houman.fathi

  5 replies

  1 week, 1 day ago

  By: Mr. Brian Gale

• Creating a subquery which conflicts with the where clause...

  Hi All, I have created a table named issues where incidents are being tracked. Every record has a m…

  krishnamurali2489

  11 replies

  1 week, 2 days ago

  By: Jeff Moden

• 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

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

  1 week, 4 days 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

  2 weeks, 1 day ago

  By: yrstruly

• Multicolumn indexes and fragmentation

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

  oRBIT

  11 replies

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

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

  3 weeks ago

  By: mjdemaris