T-SQL: size of replication specific tables
On the distribution database, you can execute the statement below to get the sizes of the internal replication specific tables
2503, 2020
2503, 2020
T-SQL: check replication backlog
You can use the code below on your distributor in order to check the backlog of the replication
1702, 2020
T-SQL: Resume or suspend all always on databases
You can use the t-sql code to resume/suspend all databases from the always on group.
2608, 2019
2608, 2019
1806, 2019
t-sql : find schema modifications which occurred the last day
In SSMS you have the “schema changes history” report. You can have the same (or even more) details from T-SQL. You can use the t-sql statement below in order find schema changes the last day, in a particular database.
1006, 2019
SSRS: Find out memory used by reporting service.
The T-SQL code below will give you an idea of the memory used by your reporting service. This query should be executed on the “reportserver ” database. Please be aware executing this statement can take some time.
1005, 2019
T-SQL: Check progress of DBCC checkdb
Doing a dbcc checkdb can take a lot of time, and in case of corruption you really want to see the progress. You can use the t-sql statement below to find the progress. Keep in mind to replace the YOUR_DB_ID to the id of your database. (find out in sys.databases)