Understanding published statistics.

Listening to “More or Less” on Radio 4 the other day, here are the items I remember..

1.What does the statistics “Ebola is up to 90% fatal” mean?

The meaning is based on CFR (Case Fatality Rate) – the ratio of reported cases to those reported cases which are fatal. The 90% figure came from a single outbreak in the Congo.

The CFR average all outbreaks since 1976 is between 60-65%.

The CFR for the current outbreak has dropped from 54% to 52% – a bit different that 90%!

2. What does the statistics that “a quarter of guide dogs working in London had been hit by a bike” mean?

The actual numbers come from a survey done for London and of 33 guide dog owners in London who responded, 14 said they had been involved in a collision. First the sample size is very small, second the person who came up with the number admitted it might be wrong as they were not good with maths!

The program reported that there are 320 registered people with guide dogs in London and all we can say is that 14 of those have been hit i.e. at least 4%!

DB2 10.5 Fixpack 4 Cancun.

Database product installation FAQ update to include Cancun http://www.smooth1.co.uk/installs/dbinstalls.html.

Also Cancun New Features document started http://www.smooth1.co.uk/db2/cancun.html

Database product installation FAQ

Database product installation FAQ http://www.smooth1.co.uk/installs.html

Currently SQL Server,DB2 10.5,Oracle,SAP ASE 16.0,Informix 12.10.FC4

Currently reading…


DBA Survivor – Become a Rockstar DBA .


All DMVs are under sys schema.



Wait stats for memory



- LCM_M_*




Wait stats for CPU




SQL Profile





SQL Server 2012 Tabular Data Model

Documented at http://msdn.microsoft.com/en-us/library/hh212945.aspx

Securing the Tabular BI Semantic Model whitepaper http://msdn.microsoft.com/en-us/library/jj127437.aspx

Securing your tabular model http://blogs.msdn.com/b/cathyk/archive/2011/11/21/securing-your-tabular-model.aspx

Getting started with Tabular Model in SQL Server 2012 http://www.mssqltips.com/sqlservertip/2821/getting-started-with-tabular-model-in-sql-server-2012–part-1/

Roles (SSAS Tabular) http://msdn.microsoft.com/en-us/library/hh213165.aspx – includes row filters and dynamic security.

Perspectives – like views http://msdn.microsoft.com/en-us/library/hh230816%28v=sql.110%29.aspx

BISM – Tabular Security Model http://paultebraak.wordpress.com/2011/09/04/bism-%E2%80%93-tabular-security-model – more on row filters.

Implement Dynamic Security by Using Row Filters http://msdn.microsoft.com/en-us/library/hh479759%28v=SQL.110%29.aspx

(DMV Question)


SQL Server 2014 Buffer Pool Extension onto SSD.

SQL Server 2014 Buffer Pool Extension onto SSD – http://www.smooth1.co.uk/sqlserver2014/bpe_ssd.html

Informix 12.10.xC4 is out!

Informix 12.10.xC4 is out! Limit session locks and use multi-tenant databases!


Get every new post delivered to your Inbox.