As an important sidebar, I don't know why you need to do this but it's generally a really bad idea to denormalize data in such a fashion.  Maybe post the...

Hi All ,

fitst you need to disable all maintenance plan   , perhaps your rebound or organise process all table without considering fragmentation .

also tha sal server audit can...

change the database compatibility to SQL2019 prior to the items below.

the optimizer is different between versions, so it's pretty standard to have to, at a minimum, rebuild statistics with...

I second that question.

@Grant Fritchey,

I think you'll absolutely love the following article...

https://getpocket.com/explore/item/looking-to-ditch-twitter-morse-code-is-back

Is someone doing any form of Index Maintenance?  It may not be in a separate job somewhere.... it may be something that someone has added to a stored procedure because...

If you can send a note to marketing@ with your specific complaints or issues, that will help. There is a proposal up with our internal IT staff/developers to do...

To stop the table locking you could use a rowlock hint:

-- Ensure we are using row-level locking
SELECT @intID = (idPool + 1)
  FROM IdConfiguration WITH...

DECLARE  @intID    BIGINT
        ,@bridgeid BIGINT = 1
;
 UPDATE dbo.bridge 
    SET...

Try not to specify the idPool column twice in the same Update statement and get rid of the Select statement.

The select statement where criteria is the same as the...

The Dynamic SQL is executed in a different context.

This is a classic "Get NextID" issue.

It would also be nice if, when you posted a code example to explain your problem, that it would at least compile.  BridgID is...

Thank you!  That'll help others, as well as preventing future dead links.

Just to add to this (Great question, BTW!)...

The zero is known as a "Date Serial" number.  DATETIME and SMALLDATETIME are capable of using Date Serial numbers directly whereas DATE, DATETIME2...

My biggest problem with all of this is that people keep poo-pooing the words "perfect" and "perfection".  That, in itself, isn't a problem but what people think after all the...