sys.dm_exec_sessions has no "history".  It only shows "active" sessions.

Dark corner of the room, fetal position in a blanket, suck thumb, twiddle hair, beer popsicle, converse with...

Awesome.  Thank you and looking forward to feedback.  This could easily be turned into a high performance "iSF"...

Please learn the difference between a row and a record. It's very important for RDBMS.

I also wish you would learn to read the posting netiquette for this forum....

Ok... here's the code to create and populate the test table.  This is what Joe Celko was talking about.  Please see the article at the first link in my signature...

Hi all,

I need to calculate average rates across days. I do not have records for all days, but I need to consider the days without the rates as carrying...

you need to use a table of dates (possibly a recursive CTE) and figure out how to put  the last working day's value in to the table.

I think you...

Hello, i have a large set of data and i need to copy the Path ( folder) for every line, for example first path it's for one .mdb, the...

Using LEAD instead of LAG.....

WITH FolderCTE AS
(
SELECT
LEAD(id, 1, null) OVER (ORDER BY id) [next_folder]
, id
, folder
FROM #sampledata 
WHERE folder is not null
)
SELECT 
sd.id
   ...

This actually sounds like a pretty cool interview question for anyone that claims to have "years of performance tuning expertise" on their resume.

First, I'd have to explain how the code...

Well, you placed this poetic perfection like a placard to polarize...

What did you want folks to use HierarchyID and Graph...

We keep going in circles.  I already...

To the best of my recollection (yeah, I was working with unit record equipment and computers way back then), the only "NULL" value on punch cards was to simply not...

It's difficult for me to believe that such a table exists and no one knows anything about it.  Find who does and ask them.