Useful tips for everyday
How does memory OLTP work? In-Memory OLTP is a specialized, memory-optimized relational data management engine and native stored procedure compiler, integrated into SQL Server. Natively…
What are dummy tables in research? Planned tables and figures (also called dummy tables) are basically an outline of a table or figure which will…
How does SQL Server measure query execution time? Probably the single most important factor when deciding which query to tune, or actively tuning a query,…
What does show warnings do in MySQL 8.0? SHOW WARNINGS is a diagnostic statement that displays information about the conditions (errors, warnings, and notes) resulting…
How to reset MySQL master to slave replication? Login to the MySQL server and execute the following command. After stopping slave go to master server…
How do I enable PostGIS extension? You can do this from within pgAdmin or via psql -U [superuser] [database] from a command line. Alternately for…
What is the purpose of sharding in MongoDB? Sharding is a method for distributing data across multiple machines. MongoDB uses sharding to support deployments with…
How do you test a staging environment? Tests in staging Smoke tests and user acceptance testing (UAT) can be performed in a staging environment. Smoke…
How can I improve my join speed in Oracle? Since a nested loops join involves accessing the inner table many times, an index on the…
How do I reduce a dimension in R? Steps : First, take absolute values of correlation matrix (Use abs(Corrmatrix) function in R) Replace all diagonal…