Common SQL Queries

SQL Queries - Common SQL Queries - Corruptions

SQL Queries - Common SQL Queries - How to check if a database has been restored on Oracle or SQL Server after being initially created

SQL Queries - Common SQL Queries - How to check the consistency on existing objects between the central and local databases

SQL Queries - Common SQL Queries - How to check the consistency on the next value to be allocated on local database for an Id

SQL Queries - Common SQL Queries - How to check the database migration history

SQL Queries - Common SQL Queries - How to check the database type

SQL Queries - Common SQL Queries - How to check the postgres sessions that are blocking another session

SQL Queries - Common SQL Queries - How to check the table size and corresponding index sizes on a schema

SQL Queries - Common SQL Queries - How to count the number of indexes in a schema

SQL Queries - Common SQL Queries - How to deduplicate a table

SQL Queries - Common SQL Queries - How to get postgres log files

SQL Queries - Common SQL Queries - How to get the list of installed extensions

SQL Queries - Common SQL Queries - How to get the size of schemas and temporary space on PostgreSQL database

SQL Queries - Common SQL Queries - How to modify existing version name in all components

SQL Queries - Common SQL Queries - How to remove all objects in an oracle schemas KB CB and MNGT which is used as CAST service

SQL Queries - Common SQL Queries - How to retrieve the count of indexes used for a schema

SQL Queries - Common SQL Queries - How to retrieve the id and the name of all types of a UA language

SQL Queries - Common SQL Queries - How to retrieve the primary key of a table

SQL Queries - Common SQL Queries - Queries on Indexes - How to get indexes and how to compare them with Standard CAST Database Indexes

SQL Queries - Common SQL Queries - Queries on Installation - Update the Unique Service ID

SQL Queries - Common SQL Queries - Queries on metamodel - How to get the list of duplicated metamodel

SQL Queries - Common SQL Queries - Queries on metamodel - How to get the list of ids with null metamodel values

SQL Queries - Common SQL Queries - Queries on Metrics - How to determine whether a metric is unified

SQL Queries - Common SQL Queries - Queries on Metrics - How to get a list of all Quality rules in KB or CB

SQL Queries - Common SQL Queries - Queries on Metrics - How to get ids of metrics given part of the name of the metric

SQL Queries - Common SQL Queries - Queries on Metrics - How to get information on activated or enabled quality rules

SQL Queries - Common SQL Queries - Queries on Modules - How to get the count of objects in the modules based on its type

SQL Queries - Common SQL Queries - Queries on Objects - How to get the extract of the content of applications in all snapshots

SQL Queries - Common SQL Queries - Queries on Source Code - How to remove source code from CAST databases

SQL Queries - Common SQL Queries - How to get Assessment Model Information for whole database server

SQL Queries - Common SQL Queries - SQL Query to list Schema name with their disk space utilization in Postgres Database