Oracle 10g: Oracle automatic memory management
In Oracle10g memory can be managed automatically by setting parameter sga_target.
Oracle - Rename DataFile
Sometimes, we need to rename Datafiles in Oracle, here we show you the alter database method.
Useful DB2 Commands
Useful DB2 Commands
How to check the current lib_dbsl Patch Level in SAP?
You go to transaction SM51, select one of the application servers with a "single-click" and hit the "Release Info" button.
Find duplicate records query
Use the following SQL statement for finding duplicates in a table. I think this should work for any relational database, not only MySQL.
Recover the forgetten SA password on Microsoft SQL Server 2008 R2
When you are using MS SQL Server in mixed mode, it is very important that you know your SA password.
MS SQL: Change Password of SA Login Using Management Studio
Login into SQL Server using Windows Authentication.
In Object Explorer, open Security folder, open Logins folder. Right Click on SA account and go to Properties.
How to check the version of MySQL server
To find out the version of MySQL server using command line on localhost run the following:
Setting, Changing And Resetting MySQL Root Passwords
This tutorial explains how you can set, change and reset (if you've forgotten the password) MySQL root passwords.
How to delete a column
To delete a column from a MySQL table run the following command:
List users with their expiration date
All sap hana users are created by default with a password expiration date. It is set at 182 days from the time the user has been created or from the time the password has been modified.
Could not split statements; SQL console content is too large
When you run an SQL Script containing a lot of rows.