Oracle partners with Microsoft

Microsoft and Oracle today announced that they are putting their differences aside to strike a strategic partnership in the cloud enterprise space. The deal covers both the private cloud and the public cloud, encompassing multiple new options. Firstly, Oracle will certify and support customers who already run its software on Windows Server to run that…

0

Hekaton and Bwtree makes the next version of SQL Server super fast

The next version of SQL Server due to release in 2014/2015 is code named hekaton. Hekaton in greek means hundreds and is expected to speed up database performance by 30X times without code changes to existing applications or hardware. Hekaton stores most frequently accessed tables in Memory. A new tool which is being in-built within…

8

PrimaryKeys can be Nonclustered too?

Yesterday, I came across a case where composite keys were being used and not justifiable. The reason shared was “Primary key by default creates a Clustered index on the table”. A primary key by default creates a Clustered index.  This happens when you use the designer to create a table. Create a simple table and…

5

Data Cubes

The term “Cube” is not new.  Most of us would associate it with Rubik cubes, invented by the Hungarian sculptor and professor of architecture in 1974.  It was so popular that in 1980 Germany recognized it as “German game of the year”   Children or the childlike would associate it with dice. A six faced…

9