Useful tips for everyday
What is Table_catalog? table_catalog. sql_identifier. Name of the database that contains the table (always the current database) table_schema. What is INFORMATION_SCHEMA table? Chapter 1 INFORMATION_SCHEMA…
How do I get to SQL command line in Linux? SQL*Plus Command-line Quick Start for UNIX Open a UNIX terminal. At the command-line prompt, enter…
Where are views stored in Postgres? A view in PostgreSQL is not that different from a table: it is a “relation”, that is “something with…
What are the hardware requirements for SQL Server cluster? SQL Server requires a minimum of 6 GB of available hard-disk space. Disk space requirements will…
What is crawl limit? We call this the “crawl rate limit,” which limits the maximum fetching rate for a given site. Simply put, this represents…
Can we use select query in case statement? The case statement in SQL returns a value on a specified condition. We can use a Case…
Is select distinct slow? Very few queries may perform faster in SELECT DISTINCT mode, and very few will perform slower (but not significantly slower) in…
Why is weak entity important? i.e., it cannot exist without the entity with which it has a relationship. It inherits at least part of it’s…
What are booking engines? A hotel booking engine is an application on hotel websites and social media pages to capture and process direct online reservations.…
How do I get SQL database out of suspect mode? Based on experience and practice, there is a proven way to recover MS SQL from…