Recent Blog ArticlesNewest TopicsMost LikesTagged:TagMore on Implicit ConversionsFirst published on MSDN on Jan 20, 2010 Yesterday, a reader posted a question asking me to comment on SQL Server's algorithm for choosing implicit conversions.Correction to my prior post on sys.dm_db_index_operational_statsFirst published on MSDN on Jul 29, 2009 In this post about the sys.Maximum Row Size and Query HintsFirst published on MSDN on Jun 24, 2009 In my last post (yes, that was two months ago), I gave an example of how a query hint could cause a query to fail.Implied Predicates and Query HintsFirst published on MSDN on Apr 28, 2009 In this post, I want to take a look at how two seemingly unrelated features of SQL Server can interact to cause a problem.OPTIMIZED Nested Loops JoinsFirst published on MSDN on Mar 18, 2009 In my past two posts, I explained how SQL Server may add a sort to the outer side of a nested loops join and showed how this sort can significantly improve perf...Optimizing I/O Performance by Sorting – Part 2First published on MSDN on Mar 04, 2009 In my last post, I discussed how SQL Server can use sorts to transform random I/Os into sequential I/Os.Optimizing I/O Performance by Sorting – Part 1First published on MSDN on Feb 25, 2009 In this post from last year, I discussed how random I/Os are slower than sequential I/Os (particularly for conventional rotating hard drives).What is the difference between sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats?First published on MSDN on Oct 30, 2008 SQL Server includes two DMVs - sys.Random PrefetchingFirst published on MSDN on Oct 07, 2008 In my last post, I explained the importance of asynchronous I/O and described how SQL Server uses sequential read ahead to boost the performance of scans.Sequential Read AheadFirst published on MSDN on Sep 23, 2008 Balancing CPU and I/O throughput is essential to achieve good overall performance and to maximize hardware utilization.
MicrosoftMicrosoftMicrosoftMicrosoft
