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

Can we use where and having clause together?

1097


What does man by sql wildcard characters in sql server?

1102


What are the 3 types of schema?

1171


To which devices can a backup be created and where should these devices be located? : sql server management studio

1099


What is store procedure? How do they work? When do you use?

989


How to create an multi-statement table-valued function?

1046


How does normalization work?

970


I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration

1131


Explain few of the new features of sql server 2008 management studio

972


What is exporting and importing utility?

1136


You want to check the syntax of a complicated update sql statement without executing it. What command should you use?

1041


how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?

1688


Explain primary key?

1005


How do I find query history in sql server?

985


How are the unique and primary key constraints different?

1123