Database
When you face issue in any of your Actimize application, it might be caused by your DB server storage performance issue. Having disk latency below 5ms is re...
Fri, 1 Oct, 2021 at 4:43 PM
Click on Import Wizard from destination schema Choose XLS format Choose XLS file and select sheet to be uploaded Change date format according to y...
Fri, 1 Oct, 2021 at 4:47 PM
1. Copy query to be checked to SQL Server Management Studio 2. Click on Display Estimated Execution Plan button as follow 3. In Execution Plan tab sh...
Fri, 1 Oct, 2021 at 5:42 PM
Error message in WLF_LIST_ALIASES.log : The following index(es) on table WLF_LIST_ALIASES were processed: index WLF_APP_PRD.ENTRY_ALIAS_UPPER_IDX partiti...
Fri, 1 Oct, 2021 at 5:51 PM
If there have process runs longer time or stuck, in below to check is the query lock by another query : 1. Check from database use session query : SELECT...
Mon, 4 Oct, 2021 at 1:34 PM
CHECK INDEX FRAGMENTATION IF avg_fragmentation_in_percent > 30 = REBUILD IF avg_fragmentation_in_percent < 30 = REORGANIZE SELECT dbschemas.[na...
Wed, 13 Oct, 2021 at 7:34 PM
SELECT sqltext.TEXT, req.session_id, req.status, req.command, req.cpu_time, req.total_elapsed_time FROM sys.dm_exec_requests req CROSS APPLY sys.dm_e...
Tue, 2 Nov, 2021 at 2:36 PM
If you have trouble because cannot login and cannot accessible after you Restoring a Database, you must change owner and connect between user login with use...
Thu, 25 Apr, 2024 at 11:59 AM
How to Create Rebuild Index in Store Procedure
Thu, 23 Feb, 2023 at 10:30 AM
What are the initial ways to best gather MSSQL server information ? • 1750 Views • (*)(*) (*) (*) (*) Issue What are the initial ways to best gather ...
Wed, 13 Mar, 2024 at 11:13 AM