SQL Server Performance

Value distribution

Discussion in 'SQL Server 2005 Analysis Services' started by stathis30_2000, May 23, 2007.

  1. stathis30_2000 New Member

    Hi !

    I have a database and I want to design a cube using analysis services. Is there a way to see the distribution of the values of a column ? I must create some intervals instead of using all the distinct values and the intervals must have almost the same number of samples.

    Thanks
  2. stathis30_2000 New Member

    I found a very useful stored procedure which does exactly what I want.

    If anyone is interested, the procedure can be found at the following address:

    http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1109458,00.html



    Thank you

Share This Page