This is similar to "Oracle Nasty Dates Finder for .NET folks!" but this time it is for numbers instead of dates! I ran into this issue as I was moving data from Oracle to SQL Server. So, you are working with Oracle using ODP.NET and you have a simple, straight-forward SELECT * FROM TABLE; Alternatively, … Continue reading Oracle ODP.NET: Resolve “Arithmetic operation resulted in an overflow” or “Specified cast is not valid”
Tag: Truncate
SQL Server: Delete In Chunks To Avoid Log Growth
Today, I had to perform a DELETE that happened to remove quite a bit of data. This caused two issues for me Log file growth which fills up the Transaction Log of the DB TempDB was getting full To avoid both problems I deleted in chunks. OPTION #1: DELETEing in Chunks is easier than you … Continue reading SQL Server: Delete In Chunks To Avoid Log Growth
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!
SQL Jana 