Monthly Archives: January 2019

Oracle 19c – Hint Reports with DBMS_XPLAN

With Oracle 19c, we got a feature which was most awaited one. It tries to answer, Whether hint is getting applied, its valid and getting used or not with DBMS_Xplan package. Initially, we used to get 10053 trace to understand … Continue reading

Rate this:

Posted in Oracle Internal, Oracle Performance | Tagged , , | Leave a comment

Generate Script for Foreign key’s in SQL Server.

During conducting one of the Proof Of Concept around “InMemory“, we had to disable foreign key to use Migration wizard provided by SSMS. Before disable, we had to create script for all foreign key for multiple tables in Database and … Continue reading

Rate this:

Posted in Helper SQL, SQL Server Learning | Tagged , , , , , , , , , | Leave a comment