Useful tips for everyday
Why does the Order of index columns matter? Indexes aren’t magic; their high-performance capabilities come from the fact that they store data in a predetermined…
How copy data from old table to new table in SQL? Using SQL Server Management Studio Open the table with columns you want to copy…
How do I convert SQL to Nosql? Write data to relational database Step 1: Connect to database. suppressWarnings(library(RMySQL)) mydb = dbConnect(MySQL(), user=’root’, password=passsword, dbname=’tb’, host=’localhost’)…
What is DB Mirroring? Database mirroring is the process of creating and managing multiple copies of a database for the purpose of database backup, recovery…
What is replica set in MongoDB? A replica set in MongoDB is a group of mongod processes that maintain the same data set. Replica sets…
What is a PG pool? Pgpool-II is a proxy software that sits between PostgreSQL servers and a PostgreSQL database client. It provides the following features:…
How do I fix my Bak? Download and Install SQL Backup Recovery. Click on Load button & select . bak file from the location path.…
What is MySQL community server? MySQL Community Edition is a freely downloadable version of the world’s most popular open source database that is supported by…
What is the use of filegroups in SQL Server? Filegroups use a proportional fill strategy across all the files within each filegroup. As data is…
How do you find non duplicates in Excel two columns? Filter for unique values or remove duplicate values To filter for unique values, click Data…