Useful tips for everyday
How are replication filters applied in MySQL 8.0? Before MySQL 8.0, replication filters were global, so filters were applied to all replication channels. From MySQL…
How do you bind variables in SQL query? Bind variables are variables you create in SQL*Plus and then reference in PL/SQL. If you create a…
How do I see Postgres user privileges? Use psql’s \dp command to display the privileges granted on existing tables and columns. See GRANT for information…
How do you create a schema in Athena? Open the Athena console at https://console.aws.amazon.com/athena/ . On the Query Editor tab, enter the Hive data definition…
How to test extended events in SQL Server? See the STARTUP STATE = ON keyword on CREATE EVENT SESSION. The SSMS UI offers a corresponding…
How do I force an index in MySQL? The index hints then are applied for each scope in the following order: {USE|FORCE} INDEX is applied…
Where can I use option recompile? OPTION(RECOMPILE) tells the server not to cache the pan for given query. This means that another execution of the…
Which is an example of a deadlock in InnoDB? A deadlock can also occur when such statements lock ranges of index records and gaps, with…
How do you set up a stored procedure to be automatically run? In Object Explorer, connect to an instance of the SQL Server Database Engine,…
What can be mined from an e mail database? Features are extracted from the email content or body, title or subject or some of the…