Hornet Dear Bernard

Dear, Dear Bernard

Posts Tagged ‘sql server

Microsoft PowerView on WinPhone7.5, IPAD, Andrios, and Window 8 – YouTube

leave a comment »

Microsoft PowerView on WinPhone7.5, IPAD, Andrios, and Window 8 – YouTube.

Cool looking analytics and BI in the next version of SQL Server

Written by bernardhornet

October 27, 2011 at 12:53 pm

Posted in Uncategorized

Tagged with , ,

Aaron Bertrand : SQL Server 2008 R2 Service Pack 1 is now available

leave a comment »

Aaron Bertrand : SQL Server 2008 R2 Service Pack 1 is now available.

Another version of SQL Server to support…

Written by bernardhornet

July 14, 2011 at 8:13 am

Posted in Uncategorized

Tagged with , , ,

MDX Function Reference (MDX)

leave a comment »

MDX Function Reference (MDX).

All the MDX functions that SQL Server supports

Written by bernardhornet

June 14, 2011 at 10:20 am

Posted in Uncategorized

Tagged with , , ,

InfoQ: Column-based Storage in SQL Server 2011

leave a comment »

When using a table with 1 TB of data and 1.44 billion rows, Microsoft claims that column-orientated queries saw a 16X speed-up in CPU time and a whopping 455X improvement in elapsed time. In real terms this means a query that took 501 seconds originally was reduced to merely 1.1 seconds. This test was performed on a 32-logical processor machine with 256GB of RAM

via InfoQ: Column-based Storage in SQL Server 2011.

Written by bernardhornet

March 8, 2011 at 8:59 am

Posted in Uncategorized

Tagged with ,