SELECT [Whims_and_Fancies] from [my_SQL_Server_Knowledge];
SELECT SCHEMA_NAME(schema_id) AS schema_name
,name AS table_name
FROM sys.tables
WHERE OBJECTPROPERTY(object_id,'IsIndexed') = 0
ORDER BY schema_name, table_name;
GO
About satya
SQL Server MVP.
SQL Master, Speaker & SQL Server helper.
16+ years of IT experience in which as a Sr. DBA and Technical Design Lead in sectors of Banking, Stock markets & Investment Banking, Manufacturing & consulting.
Out of professional activities :
Moderator - SQL Server Performance forums & MSDN forums in addition to my homepage above.
Active member of most of the SQL Server community forums.