Useful tips for everyday
What is the size of your biggest database? Yahoo tips the scales as the largest commercial database at a mere 100.4 Terabytes, running BSD Unix.…
How to count number of Records in date field? Say we have records of last ten days; we want to display total records of each…
How do I move transaction logs? In a nutshell, the three main steps involved in moving a log file to new location are: Detach the…
Are SQL indexes case sensitive? The default collations used by SQL Server and MySQL do not distinguish between upper and lower case letters—they are case-insensitive…
What is the difference between job and Scheduler in Oracle? Both allow you to schedule jobs to be executed at a given time. The main…
Can two tables have same partition name? The same partition name is allowed to occur in other partitioned tables. If a partition name is omitted,…
How do I query in SQL Plus? Running SQL Commands At the command prompt, enter the first line of the command: SELECT EMPLOYEE_ID, LAST_NAME, JOB_ID,…
How can I compare two dates in MySQL query? Instead, you should be comparing dates as dates, and then only converting them into your target…
How to dump entire databases in MySQL 8.0? To dump entire databases, do not name any tables following db_name, or use the –databases or –all-databases…
How to generate scripts in SQL Server 2008 R2? While looking through the new features and improvements in SQL Server 2008 R2, we found a…