Useful tips for everyday
How do I reclaim space from a deleted LOB? Reclaim unused rows by running the following command: ALTER TABLE SHRINK SPACE; Reclaim unused LOB columns…
How to use trigger for constraint Stack Overflow? WITH EnrolmentTallies AS ( SELECT teacher_id, COUNT(*) AS students_tally FROM Enrolment GROUP BY teacher_id ) SELECT *…
How to change password for SSIs connection manager? This can be changed through the SSIS package properties -> ProtectionLevel. You should select “EncryptAllWithPassword” and set…
What is the syntax of case statement? The SQL CASE Statement The CASE statement goes through conditions and returns a value when the first condition…
What does impdp do in Oracle Database 19.3? With oracle database release 19.3, the same impdp instruction produces the following output: Which is the default…
How to calculate item offset for pagination Stack Overflow? And there would be a total of 4 pages where the last page only has 2…
How big is the plan cache in SQL Server? By default, the plan cache is limited to 160,036 total entries (40,009 entries per bucket), and…
When do you answer only close ended questions? In a survey it is most likely that you may end up answering only close ended questions.…
How to merge two JSON columns in PostgreSQL? Using Postgres 9.4, I am looking for a way to merge two (or more) json or jsonb…
How do you create a buyer behavior model? 5 Steps to Begin Creating Customer Behavior Models (And Why You Need Them) Catalog Available Data Sources.…