Contains one row per page that failed with a minor 823 error or an 824 error. Pages are listed in this table because they are suspected of being bad, but they might actually be fine. When a suspect page is repaired, its status is updated in the event_type column. suspect_pages
Here I am giving you sample query to get database list which are not having backup since date. Other Refrence
SQL Server provides two features that track changes to data in a database: change data capture and change tracking. These features enable applications to determine the DML changes (insert, update, and delete operations) that were made to user tables in a database. Change Data Capture configuration settings ● maxtrans* — The maximum number of transactions to process in …
Track data changes using CDC in SQL Server Enterprise edition Read More »
dm_db_log_space_usage, databases
There are several ways to list dependency here is one simple way to do this. sp_MSdependencies There are several undocumented systems stored procedures and extended stored procedures in SQL Server 2005 which can be of enormous use. name: name or null (all objects of type)type: type number (see below) or nullif both are null, get …
Contains one row per database in the instance of SQL Server. If a database is not ONLINE, or AUTO_CLOSE is set to ON and the database is closed, the values of some columns may be NULL. If a database is OFFLINE, the corresponding row is not visible to low-privileged users. To see the corresponding row if the database is OFFLINE, a user must …
Using system objects we can find tables inflammations like no of row, indexes, key columns, etc. sys.tables: Returns a row for each user table in SQL Server. sys.partitions: Contains a row for each partition of all the tables and most types of indexes in the database. sys.dm_db_partition_stats: Returns page and row-count information for every partition …
he SSISDB catalog is the central point for working with Integration Services (SSIS) projects that you’ve deployed to the Integration Services server. For example, you set project and package parameters, configure environments to specify runtime values for packages, execute and troubleshoot packages, and manage Integration Services server operations. The objects that are stored in the SSISDB catalog include projects, …
SQL query find average row size in table
assembly_modules: Returns one row for each function, procedure or trigger that is defined by a common language runtime (CLR) assembly. This catalog view maps CLR stored procedures, CLR triggers, or CLR functions to their underlying implementation. Assemblies (Database Engine) – SQL Server | Microsoft Docs
