Hardware & Troubleshooting

Execute the following query to shrink and truncate log files of all the databases in the instance.

Large size of log file can be truncated using the below command. Make sure to take backup if log file is necessary. Replace the database name 'test' and log file name 'test_log' in the below below query then execute.

USE test
GO
ALTER DATABASE test SET RECOVERY SIMPLE WITH NO_WAIT
DBCC SHRINKFILE(test_log,1)
ALTER DATABASE test SET RECOVERY FULL WITH NO_WAIT
GO

Execute the below query by replacing the 'test' with the database name. EXEC sp_resetstatus 'test' ALTER DATABASE test SET EMERGENCY DBCC CheckDB ('test') ALTER DATABASE test SET SINGLE_USER WITH ROLLBACK IMMEDIATE DBCC CheckDB ('test', REPAIR_ALLOW_DATA_LOSS) ALTER DATABASE test SET MULTI_USER

Recently my pen-drive affected by Virus.

I have done through scanning using Latest antivirus.

Now all the files and folders are in hidden state. 

I have enabled the hidden files using the steps provided in the post : Enable hidden files and folders in pen-drive 

Now, How to delete the shortcuts that are in pendrive?

Hard disk, pen drive, flash drives, memory cards showing less capacity comparing to the specification provided by the manufacturer.

What's the reason for it?

How to utilize full capacity?

My 16 GB pen drive shows 14.9 GB only..

What is the difference between 2nd Generation & 3rd Generation Processors / Laptops?

What is the difference between various RAM Modules currently used? i.e., DDR, DDR2, DDR3?

Offline UPS

Offline UPS supply grid power to electrical and electronic devices during normal power supply. It switches to battery power only during power failures and other power problems. As the grid power is bypassed to the load during normal power supply, it is known as Offline UPS. As the UPS is used only during power problems it is also known as Standby UPS. Offline UPS is also spelled as Off-Line UPS or Off Line UPS.
Apart from bypassing power to the load, Offline UPS also

What is the difference between LED, LCD and TFT displays?

Start > Run > type gpedit.msc
You will see [Local Computer Policy]
Expand the [Administrative Templates] branch
Expand the [Network] branch
Highlight [QoS Packet Scheduler]
Double-click [Limit Reservable Bandwidth]
Check [Enabled]
Change [Bandwidth limit %] to 0 %
Click [Apply] [OK]
Restart
Now, enjoy the speed of your internet!

It boosted speed of internet in my pc double time.