SQL Server Fragmentation
Learn how SQL Server fragmentation can affect the performance of a query due to the order of pages and extents in a table.
Read MoreMost Popular Databases
Tuning SQL Server Memory, Part 1
Learn how using memory effectively in SQL Server 2012 can have a large impact on the system’s overall ability to scale and perform well.
Read MoreWhy Consider SQL Server Partitioning?
SQL Server partitioning can positively affect your environment and processes; this article can help you ensure that every process benefits from it.
Read MoreSQL Server tempdb Considerations
Since SQL Server database file location is so important to I/O performance, you should consider functional changes to tempdb when you create a primary data-file placement strategy.
Read MoreSQL Server Logical Unit Numbers
Learn how to determine how many logical unit numbers (LUN) you need and how big each should be when configuring SQL Server.
Read MoreAbout SQL Server Authentication
Learn about SQL Server authentication and contained users, introduced in SQL Server 2012.
Read MorePerformance 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 More