Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

what are the advanced features in sql 2008?

Answer Posted / neetika

QL Server Management Studio has the following improvements:

® In the Query Editor window, you can query multiple servers at the same time by opening query windows from registered server groups. The query results can be combined into a single results pane, or can be returned in separate results panes.
® You can access SQL Server Profiler from the Query Editor window, from the Query menu, the Query Editor toolbar, or by pressing CTRL+ALT+P.
® You can now open tables by using a Return Top n rows option.
® On the Tools/Option menu, you can specify the action that results by double-clicking tables in Object Explorer.

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration

971


Define compound operators?

862


Explain the phases a transaction has to undergo?

987


Is null in sql server?

941


Define outer join in sql server joins?

892


What is the largest component inside a field?

1027


Why use view instead of a table?

883


What is difference between rownum and row_number?

911


How to write a query with an inner join in ms sql server?

999


What is dirty read?

1041


How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

961


Why use cursor in sql server?

1007


How do I find the sql server database version?

942


Explain the concept of view and Types of views in SQL server?

944


What is unpivot?

970