Posted by Rajesh Setty. Posted In : KnowledgeBase
Posted by Rajesh Setty.
Posted by Rajesh Setty.
Posted by Rajesh Setty.
Posted by Rajesh Setty.
DMV in SQL Server 2005 #1. sys.dm_broker_activated_tasks
DMV in SQL Server 2005 #2. sys.dm_broker_connections
DMV in SQL Server 2005 #3. sys.dm_broker_forwarded_messages
DMV in SQL Server 2005 #4. sys.dm_broker_queue_monitors
DMV in SQL Server 2005 #5. sys.dm_clr_appdomains
DMV in SQL Server 2005 #6. sys.dm_clr_loaded_assemblies
DMV in SQL Server 2005 #7. sys.dm_clr_properties
DMV in SQL Server 2005 #8. sys.dm_clr_tasks
DMV in SQL Server 2005 #9. sys.dm_db_file_space_usage
DMV in ...
Posted by Rajesh Setty.
select 'DBCC Show_Statistics ('''+obje.name+''','''+ind.name+''')' from sysindexes ind Cross Apply(select name from sys.objects obj where obj.object_id = ind.id and obj.type not like 'S' ) obje
|
Posted by Rajesh Setty.
Posted by Rajesh Setty.
Posted by Rajesh Setty. Posted In : General
Posted by Rajesh Setty.