Browse by Tags

All Tags » sql improvements (RSS)
Fri, Dec 18 2009 9:02

High ROI items for SQL Server 2008

To persuade your boss to embrace an upgrade to SQL 2008, you need to know which features have high Return On Investment. They may have seen presentations talking about features like Spatial, or MERGE (and been quite impressed), but they may well have...
Posted by Rob Farley | 2 comment(s)
Filed under: , ,
Sun, Oct 12 2008 14:38

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,...
Posted by Rob Farley | 12 comment(s)
Filed under: , ,
Fri, Aug 8 2008 0:55

Ctrl+1 in SSMS for sp_who, plus more

I did this by accident, but turns out it's a really useful feature. I was just trying to zoom in on something using Zoomit , that really useful thing that I use whenever I'm presenting these days. But I didn't have Zoomit running, and so SQL...
Posted by Rob Farley | 2 comment(s)
Filed under: ,
Thu, Jul 3 2008 19:28

Design Query in Editor bug

Ok, so real database developers don't use the graphical "Design Query in Editor"... yeah, I know. Sure, there's the odd time when you're typing a query and you don't have an Object Explorer (eg, in SSIS) and a moment of weakness...
Posted by Rob Farley | 1 comment(s)
Filed under: , ,
Fri, Apr 18 2008 1:49

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...
Posted by Rob Farley | 1 comment(s)
Filed under: ,