Browse by Tags

Tagged Content List
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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. ...
  • Blog Post: 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...
Page 1 of 1 (4 items)