March 2015 - SQLPerformance.com

Indexed View Maintenance in Execution Plans

Posted by Paul White on March 26, 2015 8 Responses »

Mar 262015

Paul White (@SQL_Kiwi) provides a very thorough explanation and walk-through of the strategy SQL Server uses to maintain the data in indexed views.

Recommended Intel Processors for SQL Server 2014 – March 2015

Posted by Glenn Berry on March 24, 2015 3 Responses »

Mar 242015

Glenn Berry (@GlennAlanBerry) of SQLskills provides details about the best Intel processors available for a variety of server classes and SQL Server 2014 workloads.

Unexpected Clustered Index Fragmentation

Posted by Paul Randal on March 18, 2015 10 Responses »

Mar 182015

Paul Randal (@PaulRandal) of SQLskills describes several ways clustered index fragmentation can sneak up on us, and how it can impact your workload.

T-SQL Tuesday #64 : One Trigger or Many?

Posted by Aaron Bertrand on March 10, 2015 10 Responses »

Mar 102015

Aaron Bertrand (@AaronBertrand) follows up on a question from his triggers presentation at SQLBits, addressing the impact of trigger overhead for T-SQL Tuesday.

Monitoring Read/Write Latency

Posted by Tim Radney on March 5, 2015 No Responses »

Mar 052015

Tim Radney (@tradney) of SQLskills.com shows us how we can be proactive in monitoring our I/O subsystems for read/write latency that can affect SQL Server performance.