Open up the new SQL Server installation -> Maintenance -> Edition Upgrade SQL Server 2019 Standard Edition -> SQL Server 2019 Developer Edition Not supported. Have to uninstall SQL Server 2019 Standard Edition and then reinstall SQL Server Developer Edition. Rule “SQL Server 2019 edition upgrade” failed. The selected SQL Server instance does not meet... » read more
There are many limitations to Always On for Standard Edition, and they are all documented here. Basically, you get to use a single availability database with a single secondary replica, with no read access on the secondary replica. Issue: Unable to setup readable secondary databases on SQL Server 2019 Standard Edition Fix: Upgrade from Standard... » read more
Issue: For some reason, unknown to many in the google-verse, trying to deploy the ipsac file using SSMS 17 causes there to be a version discrepancy with the script tasks (e.g. – “version 15 is not supported in this version of SSIS, etc.). Two primary options are deploying directly from Visual Studio (I used VS... » read more
Note: The account using to run this job will need read/write access to the folder.
If a database is in Suspect Mode… Try to bring the database back online. If that does not work, try to repair the database with data loss. If that does not work, you have to restore the database from a backup file.
To Rebuild or Reorganize: That is the Question First off: ‘Reorganize’ and ‘Rebuild’ are two different operations that each reduce fragmentation in an index. They work differently toward the same end. You don’t need to run both against the same index. (I sometimes find that people are doing both against every index in a maintenance... » read more
uspDbaIndexDefrag xx_dba_parseString_udf xx_dba_indexDefragStatus xx_dba_indexDefragExclusion xx_dba_indexDefragLog Result Executing: ALTER INDEX [PK_tbTable01] ON [MyDB01].[dbo].[tbTable01] REORGANIZE Executing: ALTER INDEX [XPK_tbTable02] ON [MyDB01].[dbo].[tbTable02] REBUILD WITH (ONLINE = ON, SORT_IN_TEMPDB = ON) Executing: ALTER INDEX [PK_tbTable03] ON [MyDB01].[dbo].[tbTable03] REORGANIZE Executing: ALTER INDEX [XPKtbTable04] ON [MyDB01].[dbo].[tbTable04] REBUILD WITH (ONLINE = ON, SORT_IN_TEMPDB = ON) Executing: ALTER INDEX [PK_tbTable05] ON [MyDB01].[dbo].[tbTable05] REORGANIZE
Error: BobMgr::GetBuf: Sort Big Output Buffer write not complete after 60 seconds. SQL Server has encountered x occurrence(s) of I/O requests taking longer than 15 seconds to complete on file . The OS file handle is 0x000006A4. The offset of the latest long I/O is: 0x00000 (or) BobMgr::GetBuf: Sort Big Output Buffer write not complete... » read more