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 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.
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
In order to access photos and videos stored on your iPad/iPhone device, you have to download and install iTunes and transfer files via iTunes software. You CAN NOT access the photos and videos directly using USB cable connection. Step 1. Connect your iPad to your PC via a USB or WiFi. Step 2. Click the... » read more
OBS Studio is a free and open-source cross-platform streaming and recording program built with Qt and maintained by the OBS Project. There are versions of OBS Studio available for Microsoft Windows, macOS, Linux distributions, and BSD. OBS Project raises funds on Open Collective and Patreon. https://obsproject.com/
.NET Multi-platform App UI (.NET MAUI) is a cross-platform framework for creating native mobile and desktop apps with C# and XAML. .NET MAUI Essentials arrives this fall 2021. Alongside more details of MAUI, Microsoft says it will end updates to the Xamarin mobile app development platform in November 2022. Xamarin has been the Microsoft technology... » read more
When copying files between two computer on the network, you can either 1) remote desktop on to the computer and copy there or 2) on your local computer, open up folder with the following location… \\Server01\D$\Folder01 Option #2 coping files from your local computer will be faster.
Change your database’s Recovery Mode to SIMPLE and then delete rows in smaller batches using a while loop something like this: Keep in mind that logs could grow a lot if you don’t commit the transaction after each chunk and perform a checkpoint. This is how I would do it and take this article http://sqlperformance.com/2013/03/io-subsystem/chunk-deletes as reference,... » read more
Query to return long running transactions and cumulative CPU time in MS for open transactions in a SQL Server Database A long running transaction keeps the transaction log active from the virtual log file containing the first log record of the transaction. Truncation cannot occur from that virtual log file onward. It may leads to... » read more