S. Srivathsani


Dynamic Management Views and Functions in SQL Server 2005

DBAs have always been warned against using system tables in their code, but often there has been no other way to get information about the server. In SQL Server 2004, Dynamic Management Views have been provided that give you insight into almost every aspect of SQL Server. S. Srivathsani brings us a look at some of the DMVs and functions you can use.

4.54 (13)

2008-03-18 (first published: )

17,306 reads

Blogs

T-SQL Tuesday Retrospective #005: Reporting

By

A few weeks ago, I began answering every single T-SQL Tuesday from the beginning....

Daily Coping 25 Nov 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Database DevOps Deployment to Azure–Webinar

By

You can register now, but on Dec 3, I have a webinar with Microsoft...

Read the latest Blogs

Forums

How to know which index is invalid index on a table?

By 892717952

There are about thirty fields in a table SaleOrderLines, I created some indexes ,...

Thanksgiving 2020

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Thanksgiving 2020

Thanksgiving Visualizations

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Thanksgiving Visualizations

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers