PowerShell – Copy SQL Server Tables – Structure, Data & Indexes To Another Database/Instance

  UPDATE Mar 25, 2021: I have created an updated version of the script with enhancements and sample usage that is available at my GitHub: https://github.com/SQLJana/PowerShell/blob/c6cbe1d5b4f97026d1b00df59403dcd1ed367065/Copy-SQLTable.ps1 Requirement: Recently I got a request from a user that he wanted to copy a specific set of tables and their indexes into a new database to ship to … Continue reading PowerShell – Copy SQL Server Tables – Structure, Data & Indexes To Another Database/Instance

Oracle Gotcha For The SQL Server Developer – DDL’s COMMIT Transactions Implicitly!

If you are primarily a SQL Server developer and you are moving to Oracle, this is one of the nastiest surprises in store for you. You are so used to rolling back everything including DDL in SQL Server transactions but in Oracle, DDL inside transactions act as COMMIT. Fear not though, there are a ton … Continue reading Oracle Gotcha For The SQL Server Developer – DDL’s COMMIT Transactions Implicitly!

Oracle – TRUNCATE vs DELETE – Spoiler: TRUNCATE Wins & Why? Hours vs Seconds!

Why DELETE is bad? In Oracle, when it comes to deleting¬† ** A L L **¬†¬† the data from a table (clearing the contents of a staging table for example), using a DELETE statement is the most inefficient choice. Here are some reasons why DELETE is bad It uses UNDO It uses REDO It fires … Continue reading Oracle – TRUNCATE vs DELETE – Spoiler: TRUNCATE Wins & Why? Hours vs Seconds!

Oracle UNDO – A Basic Explanation

You might have heard the terms UNDO and REDO thrown around in conversations around space usage. In this tip, let us get a basic idea of what UNDO (formerly called ROLLBACK) is in Oracle. I promise you that this will be an interesting read and you will be happy you read this. Unlike SQL Server … Continue reading Oracle UNDO – A Basic Explanation