Cleaning Up SQL Server Indexes
Learn how to perform SQL Server Index cleanup tasks on a regular basis to prevent excessive fragmentation.
Read MoreMost Popular Performance
Why Use Both Partitioned Tables and Indexes?
Learn how to use SQL Server 2012 partitioned tables to spread a single table over multiple partitions.
Read MoreSQL Server Merge Join
Learn how the SQL Server optimizer uses merge joins to improve database performance.
Read MoreSQL Server Hash Join
Learn about the SQL Server hash join and how it can affect performance.
Read MoreSQL Server Nested Loop or Loop Join
SQL Server nested loop join are particularly effective if the outer input is small and the inner input is sorted and large. Learn more.
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 MoreWhy Alerting Tools Often Fail Database Administrators
A DBA’s point of view on why alerting tools often fail to prevent problems, and what you can do about it.
Read MoreUnderstanding the Oracle Cost-based Optimizer (CBO)
Learn how the Oracle cost-based optimizer (CBO) can impact performance.
Read MoreUsing Index Hints to Tune Oracle Performance
Knowing how to use index hints can help you improve Oracle performance tuning.
Read More