SYS2 DMVs

  •        62

A collection of scripts that simplify the usage of SQL Server 2005 and over DMVs, avoiding the user to have to write queries with tons of joins and allowing him to have directly the results he needs.

http://sys2dmvs.codeplex.com/

Tags
Implementation
License
Platform

   




Related Projects

SQL Server Partition Management


Managing SQL Server Table partitions requires creating staging tables with indexes and constraints that match a specific partition of a permanent table. This utility creates staging tables on-demand, eliminating the need modify scripts when table or index structures change.

ExportSQLScript - Export MS SQL 2008R2/2008/2005/2000 objects to script


Command line driven utility to export MS SQL objects to script files suitable for database creation and revision control. Uses 2008R2 Server Management Objects (SMO) which are compatible with SQL Server 2000, SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2.

SQL Server Partition Details Custom Reports


SQL Server Partition Details Custom Reports provides SQL Server Management Studio users with custom reports that lists table and indexed view row counts, partition boundaries and other details. This RDL uses the standard Custom report framework introduced in SQL Server 2005 SP2.

SQL 2005 Service Manager


Welcome to the SQL 2005 Service Manager project. SQL 2005 Service Manager is a replacement for the SQL Server Service Manager that came with SQL Server 2000 but is no longer shipped as part of SQL Server. It allows the management and monitoring of all local SQL Server related ...

Index Analysis


Index Analysis allows DBAs and developers to analyze the indexes in a database to determine the use, characteristics, and statistics of the index. The project contains the query written in T-SQL and report that can be opened as a custom report in SSMS.



FileSystemHelper SQL Server CLR


FileSystemHelper SQL Server CLR provides a collection of CLR stored procedures and functions for interacting with the file system. Using these stored procedures and functions will allow you to avoid enabling xp_cmdshell on your SQL Server instances.

ExpressProfiler


ExpressProfiler is a simple but good enough replacement for SQL Server Profiler. Can be used with 2005/2008/2008r2/2012/LocalDb, either express or standard

SQLS


SQLS is a simple SQL Server batch file generator. Designed to be used as part of implementations or patches to apply TSQL scripts to a SQL Server. SQL 2000 'osql' and SQL 2005/8 'sqlcmd' are supported.

SQL Trim


Function removes white spaces (incl. ones in the middle). For Microsoft SQL Server 2005/2008

Standalone SQL Agent


The Standalone SQL Agent provides SQL Express users with the ability to use the SQL Server Agent features of the database system even though Microsoft has decided to remove the SQL Agent from the SQL Express product. This project is developed using Visual Basic.NET 2008.

Fulltext Management for SQL Server (Express)


This Addin for SQL Server Management Studio allows you to manage your fulltext catalogs easily. It even works for SQL Server Express editions, so now you can use a nice GUI instead of unhandy SQL commands.

SSMS Addins


Interesting and useful Addins for SQL Server Management Studio 2005 and 2008.

Panorama Based Web Site


Generic web site example and web controls for use with SQL Server 2005 or 2008 and Panorama NovaView.

SQL Server FineBuild


FineBuild provides 1-click install and best-practice configuration of SQL Server 2014, SQL Server 2012, SQL Server 2008 R2, SQL Server 2008, and SQL Server 2005

SQL Compact data and schema script utility


This console app and SQL Server 2008 Management Studio add-in helps you better manage your SQL Compact development efforts. It allows you to script schema and data to a .sql file, which can be used in any context. It also scripts DML for use in SSMS scripts.

SQL Server Replication Explorer


SQL Server Replication Explorer is a client tool for browsing through Microsoft SQL Server replication topology. It can also be used for troubleshooting and monitoring of the Microsoft SQL Server replication.

Allocation SQL Server Management Studio Add-in


This is add-in for SQL Server Management Studio (SSMS) to display database allocation information. It builds on allocation information displayed by SQL Internals Viewer to show how data is allocated in SQL Server files. The add-in also displays information on space usage, ta...

turtle SQL


turtle SQL, a product designed to generate the SQL Server 2005/2008 documentation. It supports, export of documentation generated to Excel, Pdf and XML.

SQLSTAT2005


SQLSTAT2005 is a data collection and a data warehouse service based on SQL Server 2005 DMV and DMF performance views and functions. This product will help in doing response time analysis of your SQL Server 2005 instances over time.