Useful tips for everyday
What is the size of SSMS? The current SSMS download size is smaller, i.e., less than half of what SSMS 17. x is (~400 MB).…
How can I see the execution plan in SQL Server? There are several ways to get the estimated execution plan in SQL Server. Once the…
How does the mongorestore tool work in MongoDB? The mongorestore tool imports content from binary database dump, created by mongodump into a specific database. mongorestore…
What are indices in statistics? In statistics and research design, an index is a composite statistic – a measure of changes in a representative group…
What is the latest version of Power BI report server? Power BI Desktop (optimized for Power BI Report Server) Version: 2.73.5586.1501 (September 2019), Released: October…
How do I get Binlog position in MySQL? The steps to set up MySQL Binlog Based Replication are as follows: Step 1: Enable Binary Logging…
How to perform full vacuum in PostgreSQL database? Perform “full” vacuuming. Aggressively “freeze” tuples. Execute the vacuum or analyze commands in parallel by running njobs…
What is physical backup in PostgreSQL? Physical Backup in PostgreSQL Physical backups are all-or-nothing – you take a full copy of the database cluster and…
How do I merge rows but not columns? 1. Select the range of cells containing the values you need to merge, and expand the selection…
How do you check if a sequence exists in SQL? Below query can be triggered in Oracle Developer to check whether sequence present in DB…