July 19, 2017 at 4:03 am
Hi all, I wonder is there a good book on the use of statistical analysis in SQL SERVER 2008 that anyone is aware of
???
Thank you M
July 19, 2017 at 6:29 am
michelle.mabbs - Wednesday, July 19, 2017 4:03 AMHi all, I wonder is there a good book on the use of statistical analysis in SQL SERVER 2008 that anyone is aware of
???Thank you M
There aren't any tools built into SQL Server 2008 that are directly related to statistical analysis, so you're looking at using external tooling. I've been learning R as a language of statistical analysis. It can query the database to gather data and you can then use the functions within R to do the analysis. Now, SQL Server 2016 includes R as an external function so that you can do statistical analysis within queries. SQL Server 2017 is introducing Python for the same thing. However, with SQL Server 2008, you just have to run a regular T-SQL query externally within another tool or language to arrive at the analysis you seek.
The two books I've been learning R from are "R in Action" and "Using R for Introductory Statistics". Those will help.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 19, 2017 at 6:49 am
Grant Fritchey - Wednesday, July 19, 2017 6:29 AMmichelle.mabbs - Wednesday, July 19, 2017 4:03 AMHi all, I wonder is there a good book on the use of statistical analysis in SQL SERVER 2008 that anyone is aware of
???Thank you M
There aren't any tools built into SQL Server 2008 that are directly related to statistical analysis, so you're looking at using external tooling. I've been learning R as a language of statistical analysis. It can query the database to gather data and you can then use the functions within R to do the analysis. Now, SQL Server 2016 includes R as an external function so that you can do statistical analysis within queries. SQL Server 2017 is introducing Python for the same thing. However, with SQL Server 2008, you just have to run a regular T-SQL query externally within another tool or language to arrive at the analysis you seek.
The two books I've been learning R from are "R in Action" and "Using R for Introductory Statistics". Those will help.
Hi, thank you very much I will have a look into this
KindRegards
July 19, 2017 at 6:58 am
Statistical analysis is a broad topic and most applications only use it in a narrowly. Describe what it is you're trying to do?
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply