O'Reilly logo

Microsoft® SQL Server 2008 R2 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Object Explorer

The Object Explorer window that existed in the SQL Server 2000 Query Analyzer was integrated into SSMS in SQL Server 2005. SQL Server 2008 continues to use an integrated Object Explorer that behaves like SQL Server 2005.. The most significant feature for those folks managing a large number of database objects is the capability to populate the Object Explorer tree asynchronously. This may not hit home for folks who deal with smaller databases, but it can be a real time saver for those that are dealing with many databases on a single SQL Server instance or for those that work with databases that have a significant number of database objects. The Object Explorer tree in SSMS displays immediately and allows navigation in the tree ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required