Useful tips for everyday
How do I add a Subpartition to an existing partition in Oracle? You use the MODIFY PARTITION ADD SUBPARTITION clause of the ALTER TABLE statement…
Does TRUNCATE table free up space? Truncating a table does not give any free space back to the disk – you need to run a…
When to use interval partitioning in Oracle Database? Interval partitioning resolves the limitations built into range partitioning when a specific range is unknown by the…
How do you SET a variable in a case statement in SQL? So you need to use ELSE, i.e.: IF (@check = ‘abc’) SET @var1…
What is SQL Server Central Management server? Central management servers store a list of instances of SQL Server that is organized into one or more…
How do I remove a database owner? To change the schema owner from Sql Server Management Studio: Expand your database -> Security -> Schemas. In…
What is unique constraint in PostgreSQL? PostgreSQL provides you with the UNIQUE constraint that maintains the uniqueness of the data correctly. When a UNIQUE constraint…
Does INNER JOIN Return all rows? The SQL INNER JOIN returns all rows in table 1 (left table) that have corresponding rows in table 2…
Can a check constraint be composite? You must define a composite unique key out of line. To satisfy a unique constraint, no two rows in…
Does UNION SELECT distinct? A UNION statement effectively does a SELECT DISTINCT on the results set. If you select Distinct from Union All result set,…