Useful tips for everyday
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…
How do I know if Oracle 11g is installed? Follow these steps: From the Start menu, select All Programs, then Oracle – HOMENAME, then Oracle…
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…
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…
How do I access MariaDB client? Windows Open the command prompt by following this steps: Start -> run -> cmd -> press enter. Navigate to…
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…
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…
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…
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…
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).…