SELECT * FROM sys.dm_db_index_physical_stats (DB_ID(N'Pega73'), OBJECT_ID(N'[Schema].[TableName]'), NULL, NULL , 'DETAILED')
dbcc showcontig ('[schema].[Tablename]') with tableresults
Thank you for visiting my blog. My site is intended to share information and knowledge with others as well as a reference site for me.
Wednesday, May 1, 2019
Subscribe to:
Posts (Atom)
How to add a Database to AlwaysOn Availability Group with four different options
To add a database to an existing AlwaysOn availability group, MS has given us four options to choose from Automatic seeding Full database an...
-
Tempdb filled up last night and databases availability group are not accessible in secondary replica. After restarting a secondary SQL insta...
-
After changing a service account running SQL server, I get an error when I connect to SQL server from Management Studio from my laptop or ot...
-
I was working on a powershell script which tells me which node is AlwaysOn primary replica. We have 38 servers which participate in AlwaysOn...