Useful tips for everyday
How do I add data to a newly added column? SQL | INSERT INTO Statement INSERT INTO table_name VALUES (value1, value2, value3,…); table_name: name of…
Why do I need to create multiple files in tempdb? Another reason you might want to use multiple data files is to increase the I/O…
How do I free up unallocated space? To allocate the unallocated space as a usable hard drive in Windows, follow these steps: Open the Disk…
What are the problems with large SQL queries? In large queries, business logic can be obfuscated by the many moving parts of a query. Queries…
When to use an aggregate function in MySQL? This section describes aggregate functions that operate on sets of values. They are often used with a…
How do I see all database in MariaDB? SHOW DATABASES lists the databases on the MariaDB server host. SHOW SCHEMAS is a synonym for SHOW…
What is short-circuit Boolean evaluation why it is useful? Short-circuit evaluation means that when evaluating boolean expressions (logical AND and OR ) you can stop…
Does MongoDB automatically create collection? MongoDB creates collections automatically when you insert some documents. For example: Insert a document named seomount into a collection named…
How is database design similar to data modelling? That’s looking at the design from a high level of abstraction to an increasing level of detail.…
How do I copy a table in phpMyAdmin? Steps to Copy a MySQL table with phpMyAdmin Explained Step 1 : Log into cPanel. Step 2…