Long Running Queries Check
Sources: https://stackoverflow.com/questions/3456629/how-to-check-which-stored-procedure-is-taking-maximum-time-in-sql-server
Author
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
This isolation level allows dirty reads. One transaction may see uncommitted changes made by some other transaction. To maintain the highest level of isolation, a DBMS usually acquires locks on data, which may result in a loss of concurrency and a high locking overhead. This isolation level relaxes this property. You may want to check... » read more
Syncfusion, Add Record to List does not work
Issue: For adding records to a list, add form does not close when pressing the “Save” button. Possible Resolution: Make sure all required fields are in the form and populated.
TempDB Best Practices
The number of the TempDB data files should match the number of logical processors, up to eight files, on the machine where the SQL Server instance is installed. If the number of logical processors on that machine is greater than eight, set the number of data files to eight, with the ability to extend it... » read more
Queries that are generating the most IOs
Sources: https://techcommunity.microsoft.com/t5/sql-server/tempdb-monitoring-and-troubleshooting-io-bottleneck/ba-p/383515
Time-out occurred while waiting for buffer latch type 3
Error: Error in procedure dbo.uspXXXX Error in procedure dbo.uspXXXX Time-out occurred while waiting for buffer latch type 3 for page (6:784), database ID 2. [SQLSTATE 42000] (Error 50000) Process Failed, ERROR CODE:0 [SQLSTATE 42000] (Error 50000). The step failed. Cause: IO requests of SQL Server cannot be met by the hardware. This becomes pronounced when... » read more
Check Memory and CPU on Windows Server using Microsoft System Information (MSINFO32)
Goto “System Information” or run “msinfo32”
Why you should not shrink your data files
Now, don’t confuse shrinking the transaction log with shrinking data files. Shrinking the log may be necessary if your log has grown out of control, or as part of a process to remove excessive VLF fragmentation (see Kimberly’s excellent posts on this here and here). However, shrinking the log should be a rare operation and should not be... » read more
Reset Beats Flex
Reset Beats Flex Hold down both the power button and volume down button for 15 seconds. When the LED indicator light flashes, release the buttons. Your earphones are now reset and ready to be set up with your devices again.
Apple AirPods Bluetooth Pairing Mode
How Do I Put My AirPods Into Bluetooth Pairing Mode? Put your AirPods into the Charging Case. Keep the lid of your Charging Case open. Press and hold the setup button on the back of the Charging Case. When the status light begins to flash white, your AirPods are in Bluetooth pairing mode. Make sure... » read more