Useful tips for everyday
What are the causes of database failures? Database Failure The 3 Most Common Causes File Corruption. If one or more files in the database are…
How do I find my Oracle database hostname? Version PL/SQL, TNS versions using with Oracle. SELECT * FROM v$version; Which version of oracle you are…
How to create a unique key in SQL? The working of the unique key in SQL is given below: 1 Unique Key Constraint with CREATE…
How do I create a query builder? Build a query: On the Workspace home page, click SQL Workshop and then Query Builder. Query Builder appears.…
How do you concatenate a table in qlik sense? Even if two or more tables do not have exactly the same set of fields, it…
When should I use a materialized view? In data warehouses, you can use materialized views to precompute and store aggregated data such as the sum…
How to migrate from SQL Server 2008 to SQL Server 2014? Steps to Migrate from SQL Server 2008 R2 to SQL Server 2014: Get clean…
Where is the slow query log? /var/lib/mysql/ By default, the slow query log file is located at /var/lib/mysql/hostname-slow. log. How do I trace a mysql…
What is database recovery in SQL Server? SQL Server restore and recovery supports restoring data from backups of a whole database, a data file, or…
How do I find my lock table? You can check table lock from v$lock and dba_objects view. Below query will give you the lock details.…