I'm looking at a part of what you posted..

PatID    StartDate  EndDate    Type of Line Insert Dt  Remv Dt Pt...

I've always been concerned but, as I get older, I seriously worry about the medical world and hospitals and the people in them when I see things like the following...

I agree with what the others said.  you've basically guaranteed that there's no chance of index seeks or high performance seek/range scans by embedding columns in functions, doing a leading...

My suggestion is that you REALLY need to STUDY RESTORE in the official documentation.  Here's the link...

https://docs.microsoft.com/en-us/sql/t-sql/statements/restore-statements-transact-sql

There are several caveats and possible gotchas and if you've not done...

Hey Jeff,

"SELECT Name_04, Name_05, Name_06, Cnt = COUNT(*)"

I executed the above query in the reference (security) table and the findings are as below.  In total 1271 rows in total.

Cnt...

https://www.google.com/search?q=what+is+using+memory+in+SQL+Server

Funny that you mention that.  I do the same thing.

A long time ago, I remember that I would solve something (it wasn't SQL back then) in a dream, wake up,...

Although mostly about memory, the following article has some pretty good stuff about examining things when you have long running queries.

https://www.erikdarlingdata.com/sql-server/does-my-sql-server-need-more-memory/

Ar you saying that you still need real live "running totals" in the output?  If so, my question, again, would be WHY?  What problem would those help you solve?

Hi Experts,

I have several more than 60+ Dates and I need to know which is last valid date for a particular record ?

All the timers are extracted in a...

With large tables, it's not likely that statistics are up to date (Frederico hinted at this in his post).  What are you doing to keep statistics up to date (especially...

Easy now... in this case, the OP has pretty much stated what they want to do.  The problem with the HAVING is that it becomes difficult to select the rest...

This is supposed multi-selection question, isn't it?  If so, radio buttons aren't going to work here.

Ok... so the first and very important step is to "know thy enemy".  With that, we have to know the "gazintas" for both tables.  Run the following query one each...

I'm thinking that's still going to result in a massive accidental cross join I previously spoke of for the rows where all 3 of the join criteria are blank or...