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...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

what are the advanced features in sql 2008?

Question Posted / raavi

Answers were Sorted based on User's Feedback



what are the advanced features in sql 2008?..

Answer / sagi.rahul

New Advanced Features In SQL Server 2008: -
a. New Data Types (Date, Time, Spatial, FILESTREAM &
HIERARCHYID)
b. Resource Governor
c. Backup Compression
d. Data Compression
e. Policy-based Management
f. Filestreamdata

Is This Answer Correct ?    2 Yes 0 No

what are the advanced features in sql 2008?..

Answer / 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

More SQL Server Interview Questions

What is the difference between Drop and Truncate

20 Answers   GT Nexus, IBM,

Difference Between ORDER BY Clause and GROUP BY Clause in SQL?

0 Answers   MCN Solutions,

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

1 Answers   HCL,

What are various limitations of the views?

0 Answers  

How to enter date and time literals in ms sql server?

0 Answers  

What is sub-query in sql server?

0 Answers  

Let us say master db itself has no backup. Now you have to rebuild the db so what kind of action do you take?

1 Answers  

What kind of problems occurs if we do not implement proper locking strategy?

0 Answers  

Do you know what are the ways available in sql server to execute sql statements?

0 Answers  

What is the difference between the 2 operating modes of database mirroring?

0 Answers  

What is compound operators?

0 Answers  

Explain what is dbcc?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories