Database Administration |
SQL Server Reporting Services In Action |
SQL Server Professionals |
1 more ...
|
Activity:
50 views;
last activity : 07 06 2010 20:18:09 +0000
|
|
|
|
1
My idea on this topics is we cant not compare this things ,the best one is Oracle 10 g database
2
Locking strategy - Main Limitation of MSSQL
3
Partitioning of tables and indexes
4
Clustering and high availability
|
|||||||||||||||||||
My idea on this topics is we cant not compare this things ,the best one is Oracle 10 g database
|
We can not compare MS SQL 2005 with Oracle it self.Then how we compare MY SQL 2005 with Oracle 10g .Oracle 10 g is advance Relational database management system.In this optimization is working parllel.Here not to worry about how we do database optimization.so Oracle 10g is hundred times better than MYSQL 2005 |
1
|
|
|
I think one of the main problem of the MSSQL 2000 compared with Oracle 8i/9i for VLDB/OLTP and enterprise applications on the high-end machines was the well-known MSSQL locking strategy. This locking would cause a high lock contention with a very high possibility of deadlocks in the correct transactional flows, which could work well on any databases that provide row versioning. In addition, MSSQL 2000 lock escalation mechanism caused locks to be escalated to the block or even table level in case of high concurrency, which is very common on high end, SMP machines.
|
0
|
|
|
In SQL Server,
no range partitioning of large tables and indexes. In Oracle, a large
100 GB table can be seamlessly partitioned at the database level into
range partitions. For example, an invoice table can be partitioned
into monthly partitions. Such partitioned tables and partitioned
indexes give performance and maintenance benefits and are transparent
to the application.
|
0
|
|
Starting from late versions in MSSQL 6.5 and 7 Microsoft provides a fast failover cluster configuration. This is equivalent to the DataGuard cold failover in Oracle. Fast failover in MSSQL is pretty rapid even compared to Oracle 9i RAC Transparent Application Failover, which is advertised as a superior high-availability solution as compared to DataGuard. The exact time of “Reconfiguration” depends on the amount of locks present in the failed node and overall transaction load. At the same time a well-configured MSSQL 2000 on top of a Microsoft Cluster will failover to the other server within about 15 seconds. |
0
|
|
|
Dynamic Management Views The dynamic management views (DMV’s) in SQL Server 2005 are designed... |
|
|
11 referals
6 comments,
1828 views
|
|
|
What do you think who can be better entrepreneurs. Men or Women |
|
|
29 referals
97 arguments,
4736 views
|
|
|
Hi ,i want to do certification in oracle but i don't have appropriate idea about the... |
|
|
1 referals
1 answers,
94 views
|
|
|
|
|
|
|
|
|
|
139 referals
2 votes,
60 views
|
|
|
When we are watching news channels or any other channel or reading news papers you bump upon... |
|
|
2022 referals
11 votes,
200 views
|
|
|
we all know the perils of talking on cell phones while driving. besides being hazourdous to... |
|
|
290 referals
2 votes,
36 views
|
|
|
Mr. Karthik......please send them a private message than posting it on toostep directly which is a personal message which you have asked to the concerned person. |
This totally looks like a debate..but why have you posted it as an Idea contest Ms. Anuradha.....It would have done great if you had created this as a debate than Idea contest...as there is nothing to give Ideas under this post.......... |
Dear Prodosh...I hope you wanted to put your comment in an Idea contest stated same, but for some reason you have created this debate unknowingly....so plz put your comment in that Idea contest. |