The great thing about new versions of SQL Server is the fact that they are packed full of new features but there some that don’t really get talked about much. I found out about a concept called lightweight query execution … Continue reading
Tags: SQL Server
Related Articles
Oracle DBMS_JOB Overview
The DBMS_JOB package is actually an API into an Oracle subsystem known as the job queue. The Oracle job queue allows for the scheduling and execution of PL/SQL routines (jobs) at predefined times and/...
Using Oracle CDB and PDBs on Docker Engine with Toad for Oracle
Introduction Oracle Container Database (CDB) and Pluggable Databases (PDBs) provide modularization to Oracle Database 12c, as discussed in the article Modularization by using Oracle Database Containe...
Spotlight on Oracle – Buffer busy waits (SOO64)
Buffer busy waits Buffer busy waits occur when a session cannot access a needed block because it is in use by another session. The two most common causes are: insufficient free lists for a table...
