When running the "Invalid objects" check if a proc (for instance) references an entity on another database (on the same server) the reference is considered invalid/missing.

Consider:

• DatabaseA
  • Tables
    • MyTable1
• DatabaseB
  • Procs
    • MyProcB
      begin
      select * from DatabaseA.dbo.MyTable1
      end

When running the "Invalid objects" test the above will fail as no reference to "MyTable1" will be found in the "DatabaseB" database.

I have some foreign keys that I put together in a multicolumn index to ensure that all foreign keys are indexed. Running the following query shows me I don't have any missing foreign key indexes: source for the query

CREATE TABLE #TempForeignKeys (TableName varchar(100), ForeignKeyName varchar(100) , ObjectID int)
INSERT INTO #TempForeignKeys 
SELECT OBJ.NAME, ForKey.NAME, ForKey .[object_id] 
FROM sys.foreign_keys ForKey
INNER JOIN sys.objects OBJ
ON OBJ.[object_id] = ForKey.[parent_object_id]
WHERE OBJ.is_ms_shipped = 0
 
CREATE TABLE #TempIndexedFK (ObjectID int)
INSERT INTO #TempIndexedFK  
SELECT ObjectID      
FROM sys.foreign_key_columns ForKeyCol
JOIN sys.index_columns IDXCol
ON ForKeyCol.parent_object_id = IDXCol.[object_id]
JOIN #TempForeignKeys FK
ON  ForKeyCol.constraint_object_id = FK.ObjectID
WHERE ForKeyCol.parent_column_id = IDXCol.column_id 
 
SELECT * FROM #TempForeignKeys WHERE ObjectID NOT IN (SELECT ObjectID FROM #TempIndexedFK)
 
 
DROP TABLE #TempForeignKeys
DROP TABLE #TempIndexedFK

I tend to keep columns in a multicolumn index that I know will always be used together when joining on to my table. The rest of the foreign keys I suspect will be used separately I give them their own index.

Is it by design that the Missing Foreign Key Indexes test ignores multicolumn indexes, and if so, what is the reason behind it?

To reproduce, create a table with 2 foreign keys and add those foreign keys to one multicolumn index.

Currently, the logic check for invalid table names is:

SET @AcceptableSymbols = '_$' TABLE_NAME COLLATE SQL_LATIN1_GENERAL_CP1_CI_AI Like '%[^a-z' + @AcceptableSymbols + ']%'

The way I read that is if the table name has any character, anywhere in the table name that isn't an underscore, dollar sign, or the letters a through z, fail. A few problems in that logic:

Tables that start with underscore or dollar sign would require brackets.
Tables can have numerics in the name (just not for the first character)
Tables could have a space if they are bracketed.

Should this test assume brackets are in use when needed? Should this test actually attempt to create a table with the given name to test it's valiidty like this solution on StackOverflow?

I would like to contribute, I can add the code that checks if a single query has multiple plans
Do you agree?

Are you planning to include a license on this page? The default legal status of a repository without a license is foggy at best: https://choosealicense.com/no-permission/