… Web site. For example These Are results recently published for Microsoft SQL Server. Of course this is much more powerful system but still…
Comment: Derived Tables and Views Performance
December 14, 2007 By 14 Comments
… indices. Unbelievable. I ran the exact same nasty query in Microsoft SQL Server 2000 and it performed as expectd – lightning fast execution. The…
Comment: SysBench - benchmark tool
May 21, 2007 By 18 Comments
… fine with SQL Server 2005. But on certain occasions i receive follwong primary key violation messages… ALERT: failed to execute SQL query: `INSERT INTO sbtest values(5694934,0,’ ‘,’aaaaaaaaaaffffffffffrrrrrrrrrreeeeeeeeeeyyyyyyyyyy’)`: FATAL: 23000 [A43] [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY…
Post: Intro to OLAP
July 12, 2010 By 9 Comments
… data mart. Introduction to MDX queries and the kind of SQL which a ROLAP tool must generate to answer those queries… you are probably already using Mondrian. Closed source ROLAP servers include Microstrategy, Microsoft Analysis Services and Oracle BI. Mondrian speaks MDX, olap4j… (XMLA) is an industry standard analytical interface originally created by Microsoft, SAS and Hyperion. Whats next? Next we’ll talk about…
