Browse by Tags

• sql

• Missing Index in SQL Server 2008 - should try harder!

  Ok, maybe I'm being a little harsh, but I just feel like it should be better. Let me show you the niceness of the way that missing indexes are handled in SQL Server 2008. Using AdventureWorks (not AdventureWorks2008) on a SQL Server 2008 install, Read More... Posted Sunday, October 12, 2008 1:38 PM from Rob Farley | (Comments Off) Filed under: sql, SQL Server 2008, sql improvements

• Fuzzy in T-SQL

  SQL Server gives you Fuzzy Lookups and Fuzzy Grouping , but only in SQL Server Integration Services. It's not even on the list of SSIS enhancements for SQL Server 2008. This week at the MVP Summit, I was having a discussion about this with Jamie Thomson Read More... Posted Friday, April 18, 2008 12:49 AM from Rob Farley | (Comments Off) Filed under: SQL Server 2008, sql improvements