It's difficult to say without seeing the actual query.

You could insert the data into a temporary table, create helpful indexes on the temporary table, then query the temporary table. So...

To date, I'm the least impressed with BING AutoPilot and Claude 3.5 Sonnet.  I'm especially disappointed in Claude 3.5 Sonnet because it doesn't seem to provide references like the...

SQL Server uses memory to cache data, if you don't set a maximum it is likely to use all the memory on the machine, including memory required by the operating...

We are adding Java BigInteger support and hence we need underlying database to support this. Oracle supports this and has no issue. I assuming SQL Server's BIGINT is equivalent...

It is preferable to use SCOPE_IDENTITY() instead of @@IDENTITY

SCOPE_IDENTITY() returns the last identity value generated within the same scope (i.e. within the stored procedure)

CREATE procedure GetCounter @tableName...

deleted duplicate

• This reply was modified 4 months ago by  Jonathan AC Roberts.

Using UPDLOCK and HOLDLOCK

This approach allows you to acquire the necessary locks to ensure serialization without using the SERIALIZABLE isolation level.

CREATE PROCEDURE dbo.sp_GenerateNextNumber (
@SequenceKey nvarchar(10),
@ReferenceNumber nvarchar(25) =...

The first 3 rows out of...

Install this TVF.

Then this SQL will do the job

select x.value value1, x.value+1000001 value2
  from dbo.GENERATE_SERIES(-999999999,+999999999,1) x
;

Heh... Ok... since you brought it up, what prompt(s) did you use?

The key here is, again, the folks answering the questions shouldn't have...

Here you are courtesy of ChatGPT

-- Create TableA
drop table if exists TableA 
drop table if exists TableB 
-- Create TableA
CREATE TABLE TableA (
    JoiningID...

• This reply was modified 4 months, 2 weeks ago by  Jonathan AC Roberts.

And yet it's still absolutely stupid about certain "simple" things...  In the example below, this is NOT the right way to solve the given problem.  Even the note in...

It's faster to rebuild indexes offline.

You might also be able to get it to rebuild in parallel which will be faster: https://learn.microsoft.com/en-us/sql/relational-databases/indexes/configure-parallel-index-operations?view=sql-server-ver16

But I think the question needs...

Is this what you are looking for?:

https://learn.microsoft.com/en-us/sql/relational-databases/showplan-logical-and-physical-operators-reference?view=sql-server-ver15

.

• This reply was modified 5 months ago by  Jonathan AC Roberts. Reason: deleted duplicate post