Databases
Oracle
- Fun with NULL
- How to Restore a Table in Oracle
- How to Generate Random Data in Oracle
- Use of Index and Characterset
- Language and Use of Indexes in Oracle
- Script to kill user sessions in Oracle
- Comparison of database schemas
- How to print explain plan
- Selectivity and Execution Plan
SQL Server
- Creating ODBC system DNS with command line
- Example of an Indexed View in SQL Server
- How to Allow Remote TCP/IP Connections for SQL Server
- Misc. Dates – SQL Server
- How to Kill Active Connections to SQL Server database
- Creating Aggregate Tables
- How to Find Running Queries – SQL Server
- Hierarchical (Recursive) Queries in SQL Server
- Lock information in SQL Server
