This is a small post for finding the page count, index level and record count of an index. This script will definitely help you in Performance Tuning projects.
select i.name,i.type_desc,s.page_count,s.record_count,s.index_level from
sys.indexes i
inner join sys.dm_db_index_physical_stats(DB_ID(N'DatabaseName'),
object_id(N'TableName'),null,null,'Detailed')as s
on i.index_id = s.index_id
where i.object_id = object_id(N'dbo.TableName')
Dipu
12 years agoCould not allocate space for object ‘dbo.Enquiry_Master’.’PK_Enquiry_Master’ in database ‘MasterDB’ because the ‘PRIMARY’ filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
Varun R
12 years agoThe issue is no space in your hard drive…! Remove unwanted databases or increase HDD space..!