Useful tips for everyday
Is it possible to have more than one subquery in a statement? Multiple Row Subqueries Multiple row subquery returns one or more rows to the…
Is MySQL regexp case sensitive? Currently, REGEXP is not case sensitive, either. Both expressions are true because [:lower:] and [:upper:] are equivalent when case sensitivity…
How do I connect to Sqlplus remotely? To connect to a remote database when you start SQL*Plus, include the Oracle Net service name in your…
How do you handle missing data in database? Data Mining — Handling Missing Values the Database Ignore the data row. Use a global constant to…
Why should you have multiple databases? Good reasons to create separate databases would be to support different availability requirements or simplify administration. For example if…
Why B tree is used in indexing? B-tree used for indexing and B+tree used to store the actual records. B+tree provides sequential search capabilities in…
Why is SQL Server always encrypted in 2016? Always Encrypted is a new feature in SQL Server 2016, which encrypts the data both at rest…
Can I change SQL Server IP address? Changing the IP Address for a machine running SQL Server is not a problem at all. You’ll need…
What must a derived table have so that you can reference it later in the query? Unlike a subquery, a derived table must have an…
How to calculate auto increment for multiple columns in MySQL? For MyISAM tables, you can specify AUTO_INCREMENT on a secondary column in a multiple-column index.…