MAXDOP Settings to Limit Query to Run on Specific CPU

Query Hint MAXDOP – Maximum Degree Of Parallelism can be set to restrict query to run on a certain CPU. Please note that this query cannot restrict or dictate which CPU to be used, but for sure, it restricts the usage of number of CPUs in a single batch. Sources:

Install Microsoft Report Builder

Microsoft Report Builder is a stand-alone app for authoring paginated reports, installed on your computer by you or an administrator. An administrator typically installs and configures Reporting Services, grants permission to download Report Builder from the web portal, and manages folders and permissions to reports and shared datasets saved to the report server. For more... » read more

Manage the Size of the SSISDB (Catalog Database)

If VERSION_CLEANUP_ENABLED is set to FALSE, enable it. Update the RETENTION_WINDOW to the number best suited for business. For example, if the business requirement is to retain the operation maintenance records for 100 days, update the RETENTION_WINDOW property to 100. Note: Changing the RETENTION_WINDOW setting will cause background purging which will may fill up the... » read more

How to Clean an Epson Printer Printhead

If your Epson printer is printing out faint images, skipping lines, or is streaking your image with lines, chances are you have a clogged nozzle–a common problem many users have with Epson printers. It’s unavoidable that print heads clog over time as small amounts of ink residue dry up and collect in the nozzles. Being... » read more

ScanSnap Organizer

Download: https://www.fujitsu.com/global/products/computing/peripheral/scanners/soho/ssorganizer/ ScanSnap Organizer makes it easier than ever to view, edit, and manage your PDF and JPEG files scanned with ScanSnap. It displays documents as thumbnails that you can preview in catalogue form for efficiency when searching. With a simple user interface, it allows you to create and sort folders without opening them, and... » read more

Unable to clear transaction logs for Always On Database

Error: Getting unable to clear transaction log error when trying to run a transaction log backup. Also unable to expand log size limits. Resolution: Make sure Always On databases are working and synchronizing on all secondary database servers. You will not be able to clear the transaction log if there is a problem with Always... » read more

SQL Jobs takes longer to run via SQL Agent

Issue: SQL Job takes longer to run via SQL Agent. Very fast when run manually but takes a very long time to run via scheduled. Stored Procedure times out when called from app. Stored Procedure runs very fast when ran manually. Resolution: Restart Windows and database server.

Always On Replica Synchronization Status

Database Synchronization Status Synchronized = Secondary Replicas has caught up. No Data Loss. Synchronizing = Secondary Replicas is still catching up. Data Loss. Note: For Always On setup using “Asynchronous commit” Availability Mode, it is normal for the database to be in “Synchronizing” status. For Always On setup using “Synchronous commit” Availability Mode, the database... » read more