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 normalization 1nf 2nf 3nf?

0 Answers  

What's the difference between DELETE TABLE and TRUNCATE TABLE commands?

9 Answers  

Why should you use or avoid select * statements?

0 Answers  

I have Two table First have UserName and second is address, in address table more than value relegated to UserName table, i want to fetch 2nd address if exist other wise 1st address access

4 Answers  

Write an sql query to find the names of employees start with ‘a’?

1 Answers  

Do you know what is rank function?

0 Answers  

How can we remove orphan records from a table?

0 Answers  

How many categories of data types used by sql server?

0 Answers  

What does sql server mean?

0 Answers  

Tell me when is the update_statistics command used?

0 Answers  

Define the one-to-one relationship while designing tables.

0 Answers  

What is sqlservr.exe - process - sql server (sqlex?press)?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories