Useful tips for everyday
How can I delete data from all tables in database? Perform the delete operation on those tables. DECLARE @tableName VARCHAR(200) SET @tableName=” WHILE EXISTS. (…
How is information stored in a database? Inside a database, data is stored into tables. As we mentioned in the previous post, the S in…
How do I monitor my RDS database? You can use the following Amazon CloudWatch features with Amazon RDS: Amazon CloudWatch metrics – Amazon RDS automatically…
How do I automatically backup SQL Database? SQL Server Database Automatic Daily Backup Open SQL Server and connect the server. Right click on Maintenance Plans…
How do I setup a MySQL database? Set Up a MySQL Database on Windows Download and install a MySQL server and MySQL Connector/ODBC (which contains…
Are there any course requirements or prerequisites? A prerequisite means a course or other requirement that a student must have taken prior to enrolling in…
How is a database shared by multiple services? Use a (single) database that is shared by multiple services. Each service freely accesses data owned by…
Why use CTE instead of subquery? Difference #2: CTEs are reusable A huge advantage of CTEs is that they can be used multiple times in…
What is optimizer in Oracle Database How does optimizer make use of data dictionary? When the user submits a SQL statement for execution, the optimizer…
How to resolve ora-01031 : insufficient privileges-Ed Chen logic? Immediately, ORA-01031: insufficient privileges shows up, which tells THOMAS he doesn’t have the right privilege to…