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

Explain why variables called the most powerful component of ssis?

0 Answers  

How to use column default values in insert statements in ms sql server?

0 Answers  

What are indexes in ms sql server?

0 Answers  

How many types of cursors are there in SQL Server?

5 Answers   247Customer, CarrizalSoft Technologies,

What are the new scripting capabilities of ssms? : sql server management studio

0 Answers  

What is the difference between a unique key and primary key?

0 Answers  

What is the use of keyword with encryption.

0 Answers  

What is sql profiler. What are the default templates with it? : sql server database administration

0 Answers  

What is equi join with example?

0 Answers  

ow to bring suspect mode datbase online from scratch

0 Answers  

You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?

0 Answers  

How do you rename a table in sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories