Useful tips for everyday
How do I restore my MongoDB database? The basic way to restore a database is to use the mongorestore command to specify the backup directory…
Where to find network settings in SQL Configuration Manager? 1. Open SQL Configuration Manager (Start > Programs > Microsoft SQL Server> Configuration Tools > SQL…
How do I replicate a database in MariaDB? Slaves read the binary log (binlog) from each master to access the data for replication. On the…
When to run SP refreshview in SQL Server? If a view is not created with schemabinding, sp_refreshview should be run when changes are made to…
How do I know which index is used in SQL query? On Oracle: Determine all indexes on table: SELECT index_name FROM user_indexes WHERE table_name =…
How to connect to a DB instance in AWS? In the upper-right corner of the Amazon RDS console, choose the AWS Region of your DB…
Where is my MySQL INI file? According to http://dev.mysql.com/doc/refman/5.6/en/option-files.html, the first location MySQL will look under is in %PROGRAMDATA%\MySQL\MySQL Server 5.6\my. ini . In your…
How long does it take to restore a large database? Although, the database backup file is only 2GB, the restore can take up to 15-20…
What are the cons of using user based collaborative filtering? Disadvantages Projection in WALS. Given a new item not seen in training, if the system…
What is the meaning of analysis analysis? Analysis is the process of breaking a complex topic or substance into smaller parts in order to gain…