About SQL Server Authentication
Learn about SQL Server authentication and contained users, introduced in SQL Server 2012.
Read MoreMost Popular
Performance Implications of Thrashing an Oracle Database
Learn about the performance implications of SGA thrashing or buffer cache thrashing for Oracle databases.
Read MoreExpand the Buffer Cache to Reduce Physical Reads in an Oracle Database
Learn how exapnding the Oracle buffer cache can reduce physical reads and improve performance.
Read MoreThe Pivot Operator Is More than Just a Report Option
The PIVOT operator in SQL Server may help code readability and may shorten code implementation time. Learn how to use if effectively.
Read MoreWhy Oracle Execution Plans with Predicates are an Important Tuning Tool
Learn about the importance of reviewing Oracle SQL plans in tuning SQL statements.
Read MoreTuning “IS NULL” Query Criteria with Clever Oracle Indexing
Learn about a clever Oracle indexing strategy for queries that involve “IS NULL” criteria.
Read MoreUsing Histograms to Help Oracle Cost-Based Optimizer Make Better Decisions
Learn how histograms help Oracle’s cost-based optimizer (CBO) to make better decisions and improve performance.
Read MoreTop Objects finds PK Index in Oracle
Learn more about Oracle’s Top Objects view and how to use it.
Read MoreLooking at Linux Utilization with sar and Oracle’s V$OSSTAT
Learn some tips for looking at Linux Utilization with sar and Oracle’s V$OSSTAT.
Read MoreComparing and Merging Divergent Data in Oracle
Learn how Oracle packages and views can help validate and then re-sync database objects.
Read MoreExtended Optimizer Statistics in Oracle 11g Improve Performance
Learn how extended optimizer statistics in Oracle 11g can lead to better execution plans and improved performance.
Read MoreFinding Usable Oracle Indexes
Learn how cleaning up unused indexes can impact Oracle performance.
Read More