Hardware & Troubleshooting
Hardware, Software, OS Troubleshooting
Truncate MS SQL Database Log file
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
Repair MS SQL Corrupted or Suspected Database
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
How to delete short-cuts in pen-drive created by virus?
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?
Why pendrive not shows full capacity as specified?
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..
Difference between 2nd Generation and 3rd Generation Laptops, Processors
What is the difference between 2nd Generation & 3rd Generation Processors / Laptops?
What is the difference between DDR, DDR2 and DDR3?
What is the difference between various RAM Modules currently used? i.e., DDR, DDR2, DDR3?
Difference between Online UPS and Offline UPS
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
Difference Between LED, LCD and TFT
What is the difference between LED, LCD and TFT displays?
Increase speed of your Internet band width
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.