Browse by Tags

All Tags » sql improvements (RSS)
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: ,