@SQLBob One of the more insidious things is having a space at the end of an object name. Causes some very inconsistent behavior depending on what tool you use to query. Managed to confirm it using quotename.
@DimitriFurman I would expect to see all databases always, along with a “last seen at” time stamp on each independently, so I can judge how stale the observation is.
@erinstellato No, but I can tell when someone used the graphical designer to create a view when I script it out and the extended property for the layout comes with it and add another few hundred lines to the script 😜
@BuckWoodyMSFT No small coincidence you chose examples which all derive from Latin, where eight is octo and night is nox, though in the objective, noctem.
@sqL_handLe Many people, especially non-dba types, don’t understand the difference between rowstore and columnstore, so anything we can do to lower than impedance would be helpful I’d think.
@skreebydba Sequences on many platforms get allocated in blocks for efficiency but it means there can be gaps. Not in front of a computer to find the docs at the moment, sorry.