sql tips
Removing Transaction Log Files in SQL Server Suspends Database Mirroring
In Microsoft SQL Server 2008, you can configure the database mirroring between two database. It improves database reliability and prevent data loss situations, if one database gets damaged due to any reason. In case of failure, you can restore the copy of your database from mirror database. However, if you unintentionally remove the transaction log files on SQL database, database mirroring session is broken by principle server.
No Need For a SQL Tutorial Or to Learn SQL
Many proprietary database systems come with a report writer but are too difficult to use. They need a knowledge of SQL or they need an expensive expert to prepare the report. Sometimes there is no report writer available at all. Here is a solution.
SQL Tutorial For Beginners
Learn the basics of SQL quickly and easily in this easy to follow SQL tutorial. Learn how to query, add, modify and delete records in your Oracle database tables using SQL with this short tutorial.
Scalar subqueries tips for Oracle 9i
Scalar subqueries are a powerful enhancement to Oracle9i SQL. They allow for quick formulation of extremely complex SQL statements. Oracle’s introduction of scalar subquery support is another example of the company’s commitment to keeping pace with the evolution of the SQL language.
Some of MySQL Key area of performance tuning
6 general issues to consider when optimizing the performance of mySQL
| Related News: |
