Useful tips for everyday
How do I create a temp table from an existing table? In SQL Server you can create a temporary table based on another table by…
How can I learn data warehouse? Share this: Best Data Warehousing Courses. Coursera. data warehousing. Data Warehousing Certification. Data Warehousing Training. Edureka. Intellipaat. LinkedIn Learning.…
What is reference partitioning Oracle? Reference partitioning enables the partitioning of two tables that are related to one another by referential constraints. The partitioning key…
How does a left join work in MySQL? When joining two tables using a left join, the concepts of left and right tables are introduced.…
Can there be multiple root users? Creating another root user can be a security risk. Root has a UID of zero in /etc/passwd . This…
How to create a database with permission denied? CREATE DATABASE permission denied in database ‘master’. (Microsoft SQL Server, Error: 262) SSMS 2014 Express did not…
Which is faster to dump from MySQL or InnoDB? Dump with –tab format so you can use mysqlimport, which is faster than mysql < dumpfile.…
How do I choose a design? Good designers consider them in every solution that they choose to implement. Elegance. An elegant design solution is simple,…
Do temp tables improve performance? Even if you can’t remove a temporary table, you may be able to drastically improve performance by making sure that…
How do I copy a view from one database to another? Right click on your database and say Tasks->Generate scripts. SQL Server Management Studio is…