Skip to content

MullOverThing

Useful tips for everyday

  • Home
  • Guidelines
  • Popular
  • Miscellaneous
  • Helpful tips
  • Contributing
  • Blog
  • Home
  • Guidelines
  • Popular
  • Miscellaneous
  • Helpful tips
  • Contributing
  • Blog

  • October 9, 2020Helpful tips

    What is wait type ASYNC_NETWORK_IO?

    What is wait type ASYNC_NETWORK_IO? ASYNC_NETWORK_IO is a tell-tale sign that the application lacks efficiency in reading data it requires from its backend database. The…

    Read more
  • October 9, 2020Helpful tips

    How do I know if Oracle 11g is installed?

    How do I know if Oracle 11g is installed? Follow these steps: From the Start menu, select All Programs, then Oracle – HOMENAME, then Oracle…

    Read more
  • October 9, 2020Miscellaneous

    What can be used instead of cursor?

    What can be used instead of cursor? Temporary tables have been in use for a long time and provide an excellent way to replace cursors…

    Read more
  • October 9, 2020Contributing

    Which is better JOIN or inner query?

    Which is better JOIN or inner query? Usually joins will work faster than inner queries, but in reality it will depend on the execution plan…

    Read more
  • October 9, 2020Blog

    How do I access MariaDB client?

    How do I access MariaDB client? Windows Open the command prompt by following this steps: Start -> run -> cmd -> press enter. Navigate to…

    Read more
  • October 9, 2020Blog

    What is the Excel formula for a running balance?

    What is the Excel formula for a running balance? Calculate a running balance A C 1 Deposits Balance 2 1000 =SUM(A2-B2) 3 1245 =SUM(C2,A3-B3) How…

    Read more
  • October 9, 2020Miscellaneous

    Can we use 2 aggregate function in SQL?

    Can we use 2 aggregate function in SQL? Multiple aggregate functions in one SQL query from the same table using different conditions. I’m working on…

    Read more
  • October 9, 2020Miscellaneous

    What is the error code for OLE DB?

    What is the error code for OLE DB? Error 0xc0202009: Data Flow Task 1: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error…

    Read more
  • October 9, 2020Guidelines

    What is Phantom read in SQL Server?

    What is Phantom read in SQL Server? Phantoms in SQL Server are actually called “Phantom Reads”. This ectoplasmic phenomenon manifests itself when an identical query…

    Read more
  • October 9, 2020Guidelines

    What is a Varray?

    What is a Varray? Description The varray (variable size array) is one of the three types of collections in PL/SQL (associative array, nested table, varray).…

    Read more

Posts pagination

Previous 1 … 7,127 7,128 7,129 7,130 7,131 7,132 7,133 7,134 7,135 … 74,181 Next

Pages

  • Contact us
  • Disclaimer
  • Privacy Policy
  • Terms and Conditions

Copyright © 2021 mulloverthing.comPowered by Nutmeg

We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it.Ok