Using USE

This is a basic SQL Server tip, but a couple of folks now have commented on it being new to them while they were looking over my shoulder, so I'll post it. If you open a query window against a server which has a lengthy list of databases (Devsqlsrv1\sql2005CS comes to mind), navigating the treeview or the droplist to find the database you're after can be annoying. If you know the database you want to work in, just enter "use MyFavoriteDB" instead. It will switch the context to that database.