Oracle PL/SQL – Fastest Way To Execute Code Is? To, Not Execute It! – Function Result Caches – Part I

What is the fastest way to execute a PL/SQL function? If you paid attention to the title, your answer would be “to not execute it at all”. In fact, that is the correct answer and Oracle provides the means to do it. The magic is possible because of an Oracle feature called result cache which […]

SQL Server SSMS Templates – Get A Jump Start On Queries/Code

You are a developer or a DBA. You run queries – a lot of them. This blog post shows you how you can simplify reuse of your queries and use already pre-built ones for which you just have to pass in the specific parameter values. Frequently run queries (without SSMS templates): You run some queries … Continue reading SQL Server SSMS Templates – Get A Jump Start On Queries/Code

Merging CSV Files Fast Using DOS COPY Command (or any type of file)

Why not PowerShell? PowerShell might be the new and recommended way to do everything in the Windows command-line (and I am a hard-core PowerShell fan) but this is so easy and handy that it will probably even work in Windows 3.11 (Windows for workgroups)! Besides, I doubt that any current method in PowerShell is as … Continue reading Merging CSV Files Fast Using DOS COPY Command (or any type of file)

Oracle’s APPEND Hint – The Key Secret To Fast BULK Loading With NOLOGGING!

Oracle's logical storage structures: To developers who work with Oracle, the concept of tablespace is familiar.  We create tables and indexes in tablespaces taking appropriate care not to place all of our data into one tablespace. Let us take a quick look at the logical structure of an Oracle database A database has one or … Continue reading Oracle’s APPEND Hint – The Key Secret To Fast BULK Loading With NOLOGGING!