LIST ALL TABLES WITHOUT A CLUSTERED INDEX
select * from sysobjects where xtype = ‘U’ and id not in (select id from sysindexes where indid = 1)
Categories
- Administration
- BACKUP
- Binary Data
- BLOB
- Blocking
- Books
- Cache
- CHECKDB
- CMD
- Database Mail
- Date and Time in SQL Server
- DBCC
- Deadlocking
- DTS
- Error Log
- Errors
- Featured
- FileStream
- Free SQL Tools
- Hyper-V Environment
- Images
- Indexes
- Interview Questions
- LOB
- Locks
- Log
- MarkLogic
- Memory
- Missing Indexes
- MS Tools
- Networking
- Performance Analysis
- Performance Counters
- Procedure and buffer cache
- Reporting Services
- Security
- Service Packs for SQL Server 2005
- Settings and Configurations
- SQL 2005 T-SQL Enhancements
- SQL Scripts
- SQL Server
- SQL Server 2000
- SQL Server 2000 Service Packs
- SQL Server 2005
- SQL Server 2008
- SQL ServeR 2008 R2 Parallel Data warehouse
- SQL Server Best Practices
- SQL Server Express
- SQL Server Licensing
- SQL Server Pricing
- SQL Server Service Packs
- SQL Server Version Builds
- SQL Server White Papers
- T-SQL
- TEMPDB
- Tools
- TRANSACTIONS
[...] LIST ALL TABLES WITHOUT A CLUSTERED INDEX Start SQL SQL Server Posted by root 2 hours 3 minutes ago (http://www.startsql.com) Apr 3 2009 2009 start sql sql server articles and tutorials powered by wordpress branfordmagazine theme by michael oeser Discuss | Bury | News | LIST ALL TABLES WITHOUT A CLUSTERED INDEX Start SQL SQL Server [...]