Sql-server – How present the result table below the last result query table, SSMS 2017

There's nothing out of the box that will let you do this.

This is kind of confusing... because the Properties window never shows properties about anything in Object Explorer. If you right-click | Properties on anything in Object Explorer, you always get a pop-up dialog box. The Properties window only shows properties for objects that appear in select MDI-style windows, such as query windows.

Having said that, even though there's no way to do this, I'm not even sure it's such a good idea.

In order to return that kind of information to the UI, SSMS has to hit the server with a metadata query. SSMS is a data-driven application; it's just special in that it operates on SQL Server itself. IntelliSense works the same way. If you're on a production server, you probably don't want this kind of thing enabled because every time you touch a different node in Object Explorer (which is very frequently), it will have to hit the server to retrieve the data. And then you get into a debate about how to turn it off, and ......

You could try a different query:

SELECT ItemID
  FROM (SELECT ItemID
              ,ROW_NUMBER() OVER (PARTITION BY ItemID ORDER BY TimeStamp DESC) rn
              ,LocationId
          FROM events
         WHERE TimeStamp < '2017-01-01 11:00'
       ) e1
  WHERE LocationId = 1
    AND rn = 1
;

No promises that this will do any better (it could actually be worse); it's just a different approach.

Also - if it makes sense, you may want to put a lower bound on the possible TimeStamp values; if you can ignore everything more than 12 hours prior to the time you're looking for, that could eliminate a large number of rows.