Useful tips for everyday
Which key refers to a primary key of another table? A foreign key is a set of one or more columns in a table that…
Is there a tool to speed up MySQL dumps? This tool dumps MySQL tables in parallel. It is a much smarter mysqldump that can either…
How do I get weekday in PostgreSQL? If you want the text version of the weekday then you can use the to_char(date, format) function supplying…
How does pt-table-checksum work? Usage. pt-table-checksum performs an online replication consistency check by executing checksum queries on the master, which produces different results on replicas…
What is a best practice when using the delete statement? One final good practice to use when deleting data from a database is to always…
Can you host MongoDB locally? To connect to your local MongoDB, you set Hostname to localhost and Port to 27017 . These values are the…
How to call sys.dm _ exec _ requests ( Transact-SQL )? Returns information about each request that is executing in SQL Server. For more information…
How do I find my SQL Tuning Advisor? How to Run Oracle 12c’s SQL Tuning Advisor Use PL/SQL and the internal package DBMS_SQL_TUNE to create…
How is update statement different from Alter? UPDATE Command is a Data Manipulation Language (DML). Alter command will perform the action on structure level and…
How do you search for a procedure? Below are the steps for using filter settings to find stored procedure. In the Object Explorer in SQL…