SQL Server – SSRS – Introduction to Reporting Services

SQL Server reporting is a powerful feature in SQL Server 2008. But I think most of the persons don’t know its scalability. When I  interview  database developers for my company, I saw lot of resumes sowing experience in SSRS. But when we ask some real time scenario question, the candidate will be in trouble. SSRS is a deep subject and lot of features in it.let’s learn its features

Who uses the Report?

Reports are mainly used by the Business Managers, Business information workers, and System Administration and Database Administration workers, Software developers. Look at this below pie chart for the SSRS users.

Evolution of SSRS

Reporting Services starts from SQL Server 2000. In SQL Server 2000 reporting was done through the visual studio which should be purchased separately. From SQL Server 2005 onwards we are using BIDS i.e. Business intelligence development studio for developing reports.



SSRS vs Microsoft Access

SQL SERVER – DMV – For finding the Page count, index level, record count of an Index

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')