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
Creating a linked server called “RPT” that connect into SERVER01… Note: When generating the linked server from a script from an existing database server, the rmtpassword parameter will not be set. After the linked server has been created, go to properties of the linked server and set the security context.
Error: The filegroup "xxxx" has no files assigned to it. Tables, indexes, text columns, ntext columns, and image columns cannot be populated on this filegroup until a file is added. Fix: Sources: https://forums.asp.net/t/1397838.aspx?The+filegroup+comn_data+has+no+files+assigned+to+it+sql