Find Out Tables With No Primary Key/Index – SQL Server 2005

I read the other day about indexing small tables I’d like to test this on my database but first I would need to find out which tables do not have an index and/or a primary key. Pinal Dave wrote about finding tables without a clustered index or a primary key: SELECT DISTINCT [TABLE] = OBJECT_NAME(OBJECT_ID) [...]

Read Full Post »