Heh... Like I tell people, I don't hate computers... I hate the people that write the code and the people that don't test it properly.

And you don't even know if...

Nice question, Steve!

Like I said, glad to "meet" you.

The reference you provided is very helpful but it doesn't tell the OP how to find content like you did for the first thing...

Someone like Paul White could answer that...

The tran log I/O seems really high to me, as does query store.  Without having more esoteric knowledge of the system, I'm hesitant to make any judgement on that.

I will...

I was shocked to learn that this table still exists in SQL Server, and nobody is talking about it ^^. It seems to be around since the 80s as...

Nothing like shifting gears but, whatever.  It's also not always the "better" way.  "It Depends".

Ah... never mind... I found the source.

https://learn.microsoft.com/en-us/sql/relational-databases/performance/display-the-estimated-execution-plan

Consider telling the OP the search you did to find this documentation so that they may help themselves in the future.  I believe it's...

@Sridevi Kakolu...

First, welcome aboard!

Just to ask the question (and no argument from me one way or the other), did you actually construct all of your first reply or did you...

• This reply was modified 2 years, 9 months ago by Jeff Moden. Reason: Change the wording a bit and add a secondary question

Welcome aboard, Glenn!

I've seen issues repeatedly with "SELECT ... INTO <new_table>" causing blocking (on SQL 2016).  When we adjust the code to split the table creation and...

I've seen issues repeatedly with "SELECT ... INTO <new_table>" causing blocking (on SQL 2016).  When we adjust the code to split the table creation and the table...

I've seen issues repeatedly with "SELECT ... INTO <new_table>" causing blocking (on SQL 2016).  When we adjust the code to split the table creation and the table load the...

Just in case anyone else is reading this and doesn't know, Lynn is anything but a "Ring Knocker".  He's a regular on these forums, has written some great articles, and...

I absolutely agree that it may not "be the listener" at fault... especially after seeing so many different "speakers".  I definitely believe we're on the same page in that area.

On...