Like I said on the other thread with the identical name (Note: there is zero need to double post on this forum)...

This sounds like either a "Connection Leak" or a...

This sounds like either a "Connection Leak" or a "Memory Leak".  A "Connection Leak" is where no connection is ever closed and everyone gets a new connection (which take memory)...

I agree... great post but it should be an article.

I also add...

6. While even Microsoft hasn't followed suit, NOT using semi-colon terminators has been deprecated since 2005 came out.

7.  Both...

I don't know 5hit from Shinola in Powershell and so I tried something different... here's the link to the thread I worked through...

https://www.perplexity.ai/search/using-powershell-how-to-search-hGZTTLw2Rmi4v81v3IwqEA#2

I'm not...

I don't know 5hit from Shinola in Powershell and so I tried something different... here's the link to the thread I worked through...

https://www.perplexity.ai/search/using-powershell-how-to-search-hGZTTLw2Rmi4v81v3IwqEA#2

I'm not testing...

Thanks for the reply, Frederico.

I don't know about folks being "trolls" but I've never seen anywhere on this...

The SQL Server documentation says that "global temporary tables are visible to all sessions" and it doesn't seem to identify a work around.  That also means that you cannot assign...

I'm curious... have any of you that said that you'd be happy to do reviews of articles ever been asked to do an article review?

It's better to NOT drop TempTables.  The "schema" can be reused even though they go out of scope and "disappear" at the end of each session.

This is a parent/child list.  There's a whole lot more that can be done with it if it's recognized for what it can do including but not limited to "Nest...

Wouldn't it be nice if Microsoft finally figured out that there's been math co-processors built into CPU chips since the mid-'90's???  Even the decimal datatype had issues with resetting the...

Just so people can play if they want, here's all the code I played with.

My findings are that if you can have a Clustered Index on the RowNumber column of...

Ah... My apologies, Chrissy.  When you said you could "guarantee the order", I mistook...

It's frequently obvious when code is not written by such folks when the OP comes back in a few months saying that,...

My suggestion is that you need to stop taking chances and hire a consultant to set you up correctly because it sounds like you're not just storing personal data (which...