Explain couple pf features of SQL server

Answer Posted / vimalssssss

1.SQL server is more user friendly and takes less time to
install
2.A database administrator can manage comparatively more
number of SQL server databases than Oracle
3.SQL server also has advanced features like advanced
compression, data mining, partitioning, OLAP, enterprise
reporting included in the package, while businesses who use
Oracle servers have to purchase these features separately.

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security

541


Explain query editor regions

610


Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

631


how to trace the traffic hitting a sql server? : Sql server database administration

1121


How to Check if table exists in sql server?

615






How efficient you are in oracle and SQL server?

633


How to provide login information for a new odbc dsn?

536


Is sql server difficult to learn?

518


Does table partitioning improve performance?

530


What are the dmvs? : sql server database administration

592


What is cursors? And what are the different types of cursor?

551


Explain difference between cross join and full outer join?

554


How do you Implement SSIS Packages in your Project?

1508


Do you know what is bit data type and whats the information that can be stored inside a bit column?

546


application server is slow what may be the problem

1778