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
Can we use where and having clause together?
What does man by sql wildcard characters in sql server?
What are the 3 types of schema?
To which devices can a backup be created and where should these devices be located? : sql server management studio
What is store procedure? How do they work? When do you use?
How to create an multi-statement table-valued function?
How does normalization work?
I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration
Explain few of the new features of sql server 2008 management studio
What is exporting and importing utility?
You want to check the syntax of a complicated update sql statement without executing it. What command should you use?
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?
Explain primary key?
How do I find query history in sql server?
How are the unique and primary key constraints different?