Blogs

Browse by Tags

• Maximum Degree of Parallelism and Hyperthreading

  For those who are challenged with deciphering how to configure the max degree of parallelism on a server where hyperthreading is enabled, the max degree of parallelism configuration is based on physical processors and not logical processors. I recently Read More... Posted Monday, November 13, 2006 10:13 AM by Lara Rubbelke | 1 Comments Filed under: SQL Server 2005 Optimizer Enhancements

• Missing Indexes and Unused Indexes

  I had a short "isn't this cool" featurette talk with the Twin Cities Database User Group on May 11 about a few new SQL Server 2005 database management views which will help us assess index usage and needs. As I promised the group, attached are the samples Read More... Posted Sunday, May 14, 2006 1:33 PM by Lara Rubbelke | 4 Comments Filed under: SQL Server 2005 Optimizer Enhancements Attachment(s): IndexTuning_Index_dm_views.zip

• SQL Server 2005 and Substring Searches

  SQL Server 2005 statistics are now built on substring character in text, ntext, char, varchar, and nvarchar columns. This greatly improves string searches using wildcard characters. SQL Server 2000 did not always generate the best plan or choose the right Read More... Posted Tuesday, March 07, 2006 6:56 PM by Lara Rubbelke | 1 Comments Filed under: SQL Server 2005 Optimizer Enhancements

• Transitive Law and the SQL Server 2005 Optimizer

  As with all other SQL Server upgrades (and recent SQL Server 2000 service packs), significant work was made to the algorithms driving the query optimizer to improve how SQL Server decides to execute a SQL statement. For example, SQL Server 2000 did not Read More... Posted Monday, March 06, 2006 4:32 PM by Lara Rubbelke | 0 Comments Filed under: SQL Server 2005 Optimizer Enhancements