There are a few things to unpack here.  From your screenshot, I can't be certain which transaction it's referring to.  However, you can clearly see that there is blocking occurring...

Removed Duplicate

• This reply was modified 1 year, 8 months ago by  Y.B.. Reason: Duplicate Post

Wow.  Thanks Jason.  I seriously had no clue.  Like I said, my aim is to help, not collect accolades for a resume but that comment just made the...

1000% this!

Despite being almost...

Yeah, I have to admit this one was a little confusing.  According to the documentation "Value 4" on the user options table is referring to CURSON_CLOSE_ON_COMMIT.  If you take it...

That is part of a package of free tools provided by the...

The question is a little vague so I'm afraid I can only give a broad answer in return.  DEV/Staging environments don't typically have the same amount of data so check...

Hi, excellent post, I have taken it and put it into practice, and it works very well for me to redo the whole nested set, But I want to...

I just recently updated my home desktop.  I thought to myself that I just needed a new CPU to upgrade to Windows 11.  Which as you mentioned required a new...

OMG Jeff, I almost spit out my drink after seeing the "Dashboard" image.  The truth is some will want it in Excel no matter how great the Dashboard is.  It's...

Before I had access to monitoring tools I found (and still do) 'sp_WhoIsActive' to be immensely helpful to gain insight as to what is happening right now.

I've literally built 100's of them.  One of my first jobs in the IT field was for a College that needed to refresh the PC's in their labs and classrooms. ...

This made my...

It's unfortunate that so many people believe SQL Express to be an "inferior" product.  While it has limitations (Size, CPU, Memory), it is often more than enough for some lightweight/stand-alone...

I think many of us here would be happy to provide an example if you provided some DDL we could work from.  However, if you really just want some research...