Viewing 5 posts - 1 through 6 (of 6 total)
Thanks for pointing this out. I missed to add the default datetime constraint for DataUpdateON column of the table. Please use below updated script to create the table-
CREATE TABLE [DBUtility].[dbo].[tbl_DatabaseFileSpace](
[InstanceName]...
September 19, 2025 at 6:51 am
In case of even data distribution, with three execution plans, there are chances that it takes additional space in plan cache. Also, there are chances that it might confuse the...
September 19, 2025 at 6:42 am
You posted "After you create the Availability Group, SQL Server automatically adds two additional system databases—SQLAG-2022_master and SQLAG-2022_msdb". However, in the picture the new system databases are not in the...
September 2, 2025 at 6:28 am
No there is noting indicative which we found the in the logs. It only contains generic messages of failover and timeouts.
September 1, 2025 at 7:53 am
Thanks Phil for sharing the alternative to do. I never used VS database project for schema comparison.
The idea of creating such script came as there was a requirement came to...
July 24, 2025 at 12:47 pm
Viewing 5 posts - 1 through 6 (of 6 total)