Re: The best elegant solution to override 65k rows limit in a sheet

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Harlan

I'm sorry that your jerry-rigged spreadsheet program isn't flexible
enough to use single or double quotes.. I am pretty sure that real
reporting programs-- SQL Server and Access allows these pretty much
interchangeably.

I'm so sorry that you work for a stupid company; SQL Server is WINNING
THIS WAR.

-----------------------------------
>>From OLAPreport.com - an independent source of BI information
-----------------------------------
http://www.olapreport.com/market.htm - MS is by far the biggest seller
of BI. This is going to mushroom with the release of Maestro--
Microsoft's real entry into the OLAP client market.

-----------------------------------
>>From Steve Ballmer, TechEd 2005
We have over 50 percent unit share with SQL Server today and we think
we can just keep ramping that up.
-----------------------------------
Also
-----------------------------------
>>From http://www.eweek.com/article2/0,1895,1839686,00.asp
-----------------------------------------------------------------
A key problem with DB2 was that they chose to follow an options pricing
model similar to Oracle's versus a bundled model that Microsoft
embraced.

This is important because IBM essentially loses its value proposition
versus Oracle when you start adding on optional features such as cube
views, OLAP and data mining.

The separate options approach is required by Oracle because it is so
dependent on its database revenue and needs opportunities to keep
coming back to existing accounts.

IBM on the other hand, is more akin to Microsoft in its revenue
diversity.

It could have bundled much more functionality at a price that undercut
Oracle significantly, but it chose not to.

It also would have presented the market with a clearly simplified
licensing model, which the market desperately wants, especially as a
counterpoint to Oracle.
.....
Windows

I don't believe there is much IBM or any other vendor can do long-term
on Windows to stem the growth of Microsoft SQL Server.

However, with Windows currently commanding 40 percent of the server
market and with estimates pointing to a greater than 50 percent share
by 2010, it is a key platform in which to remain relevant.

Certainly there will still be a significant number or organizations
that will prefer to hedge their bets by utilizing database software
that will run on multiple operating systems.

The problem for IBM is that DB2 is actually losing share on Windows
(-4.4 percent in 2004), according to Gartner.

.

Relevant Pages

  • Re: IOT, memory and transaction time
    ... easily generate it with DBMS_METADATA.GET_DDL if your verison of Oracle ... were pretty consistent no matter how big the table (this transaction ... FOREIGN KEY (versionNo) REFERENCES T_TRANSACTIONS, ... Oracle provides read consistency and SQL Server ...
    (comp.databases.oracle.misc)
  • Re: How to Create Local Temporary Table
    ... I have worked with both Oracle and SQL Server for some time and have grown to appreciate how much more mature Oracle is than SQL Server. ... When most think of scripting in Windows, they think of DOS command line scripting. ...
    (comp.databases.oracle.server)
  • Re: Database or store to handle 30 Mb/sec and 40,000 inserts/sec
    ... "Writers block readers and readers block writers in SQLServer. ... getting around this fundamental issue and because of it SQL Server ... admitted they can happen in Oracle, I guess Oracle should never been used ... isolation level but you will always disagree because you follow doctorine ...
    (comp.databases.oracle.server)
  • Re: IOT, memory and transaction time
    ... easily generate it with DBMS_METADATA.GET_DDL if your verison of Oracle ... If it was the update statement that references ... FOREIGN KEY (versionNo) REFERENCES T_TRANSACTIONS, ... There are however differences how both products deal with concurrency; in Oracle readers don't get blocked while this may happen in SQL Server. ...
    (comp.databases.oracle.misc)
  • Re: Import problems on Windows Server
    ... XP is fine, so is Vista, like you I use them day in day out, around 12 hours ... a day myself too - laptops and the desktop i'm writing this on. ... I use SQL Server on XP and Vista for writing and demo'ing stuff, ... those are the same problems in the Oracle world. ...
    (comp.databases.oracle.server)