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.
Database
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.
Oracle 10g: Oracle Virtual Indexes - How to
Virtual index is a feature of Oracle 10 and Oracle 9. The purpose of virtual indexes is simulate the existence of an index, without actually building it, so you can explain plan as if the index existed.
Errors While running "relink all"
When you want to relink Oracle, you get some errors like Command failed for target `libnmemso'
How to get the List of Users in ASE
There are multiple ways of getting the list of users in Sybase database. You may use one of the methods below.
How to retrieve user password expiration date in sap hana?
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.
Msg 10331 Permission denied, You need the following permission(s) to run this command: SETUSER
2663238 - Msg 10331 Permission denied, You need the following permission(s) to run this command: SETUSER - SAP ASE on Business Suite
Stoping the ASE Sybase Database
You can use the saphost agent, or directly the isql command line
HANA: How to drop schema
HANA: How to drop schema
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.
Managing Oracle on Windows
If you manage Oracle on Windows, you probably have wondered why it is so difficult to work out which Oracle instances are running and which ORACLE_HOMEs they use.
Most Read
All
Month
Week
