Explain couple pf features of SQL server
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / vimsssssssssss
1. A database administrator can manage over 65 critical SQL
server databases, where as the same administrator can
manage only 15 Oracle critical databases.
2. SQL server is more user friendly and takes less time to
install when compared to Oracle server.
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 |
What is instead of trigger sql server?
What is a performance monitor?
Working with TLogs
How to maintain a fill factor in existing indexes?
How dts is used to extract, transform and consolidate data?
What is faster join or union?
What are the restrictions while creating batches in sql server?
What are dml triggers and types of dml triggers?
What is candidate key with example?
how do u find least salary in a table
What is a benefit of using an after insert trigger over using a before insert trigger?
What is the status of services on passive node for failover cluster in sql server? : sql server database administration
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)