The XML tools are what I see used the least where they could be used more. Both XQuery and For XML have a myriad of uses and improvements over prior tools. But I still see posts in the SQL 2008 forums here where people are instatiating XML objects using the SQL 2000 system procs.
Filtered indexes are definitely a good feature. Work beautifully on large tables with bit fields that need to be filtered by routinely.
There are plenty of others, I'm sure.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon