How to calculate Easter date
Here is the sample Date datatype with int datatype Reference:
July 2020
SQL Server Tables and row counts
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 …
SSIS catalog database read
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, …
Database files information using query
database_files: Contains a row per file of a database as stored in the database itself. This is a per-database view Reference: https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-database-files-transact-sql?view=sql-server-ver15 https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-filegroups-transact-sql?view=sql-server-ver15 https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-master-files-transact-sql?view=sql-server-ver15
Backup History using TSQL
Using system object we can find the backup history details. Backupmediafamily: Contains one row for each media family. If a media family resides in a mirrored media set, the family has a separate row for each mirror in the media set. This table is stored in the msdb database. Backupset: Contains a row for each backup set. …
Query statistics for a single table
sys.stats : Contains a row for each statistics object that exists for the tables, indexes, and indexed views in the database in SQL Server. sys.dm_db_stats_properties: Returns properties of statistics for the specified database object (table or indexed view) in the current SQL Server database. Use the following query to identify statistics auto-created by SQL Server …
Find all constraints that need to be entrusted.
The last column of the result set is the SQL command to execute to entrust the constraint. Using cursor
Get fragmentation info for the tables
dm_db_index_physical_stats:Returns size and fragmentation information for the data and indexes of the specified table or view in SQL Server. For an index, one row is returned for each level of the B-tree in each partition. https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-db-index-physical-stats-transact-sql?view=sql-server-ver15
How to read Deadlock from system health of SQL server
Here is a sample query to help read deadlock from sys.health extended events.
