Except #tmp is unique if you were to look in tempdb.  The local #tmp table is uniquely named in tempdb.  This has to be true for local temporary tables or...

Looks like Ray may still be undefeated after tonight.
BulkLogged division has a three way tie for first with three of us are 4-3-0.

Here is what I will tell you.  You have a query to identify all the columnstore indexes.  Now you need a query to identify all the non-clustered indexes.  Then you...

Too early on a Monday morning:
Try this:

WITH BaseTables AS (
SELECT
[t].[object_id]
, TableName = [t].[name]
, rowcnt =...

Since you seem to be having such a hard time with this and against my best instincts, give this a try:

WITH BaseTables AS (
SELECT

Maybe some day I will find that position that lets me work from home.  Most likely that will be called retirement.

Get them to fix the dates for the next import or you are going to find yourself struggling with all this again.

Been a while but I thought there was a way to update the PATH without directly editing the registry.  I will have to do some research over the weekend.