What's your favorite "hidden" feature of SQL 2005

[Catadmin]

This is a whimsicial thread. In the few weeks I've been working with SQL Server 2005, I've found a lot of bugs/problems and posted in various forums about them. However, I've also found a few nifty little features that either weren't in SQL 2000 or that I didn't know about in SQL 2000. So, I thought, why not see what un-advertised features other people have found?

My favorite is the Query -> Connections file path. No longer does disconnecting from a server close your Query window, causing you to have to cut-n-paste from one query window to another if you want to run the same query on another instance / server. Now you can use Query->Connections->Disconnect and then Query->Connections->Connect on the same query window and run your code against Dev and then Test. WHOOHOO! Less work for me. @=)

So, you tell me. What un-advertised feature have you discovered in SQL Server 2005 (it can be any interface, BIDS, SSMS, etc.) that you've fallen in love with?

Catadmin


Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[timscronin]

I can only thank whoever hid all the stuff that was so easy and logical to find in 2000 EM, that I can't find now. When I find this I will present you with my favorite hidden stuff

 

[Catadmin]

Ouch. Good point. You'd think they would have kept the good stuff from 2000 instead of File-13ing it.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"