Calculating odds ratio with T-SQL and R
Simple steps towards understanding what is an Odds Ratio, and how do we arrive at it using TSQL and R scripts.
2016-08-30
2,161 reads
Statistical Analysis (mathematics)
Using Microsoft R in Enterprise Environments
This article talks about using the the positive aspects of setting up R in enterprise environment and give instructions on first steps how to do it.
2016-08-25
2,361 reads
Calculate the Statistical Mode in SQL Server using T-SQL
Next to the average and the median, there is another statistical value that you can calculate over a set: the mode. This is the value that appears the most often in the set. The average and the median are straight forward to calculate with T-SQL in SQL Server, but how can we determine the mode using T-SQL?
2015-03-16
6,205 reads
Data Science for SQL Folks: Leveraging SQL and R
Learn about how to build value driven analytics with SQL Server and R.
2016-03-04 (first published: 2014-11-03)
15,499 reads
Global return for user permission
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-11-08
RE: Update with insert of zero
How about something like this:select CASE PATINDEX( '%[a-Z]%', col1) WHEN 0 THEN stuff('000',4-len(col1),len(col1),col1) ELSE stuff('000',4-PATINDEX( '%[a-Z]%', col1)+1,len(col1),col1) END from test1Where test1 is the table in question and col1 is the column you are working on.
2004-10-06
RE: Security: Is there a way to lock down SQL Server Agent ??
Please be carefull not to cross post or duplicate. Addiitonal comments http://qa.sqlservercentral.com/forums/shwmessage.aspx?forumid=6&messageid=123292#bm123397
2004-06-28
RE: Optimal Pivot Query
Thanks to all.I am choosing Sachin's solution that was better than what I had come up with.
2004-05-16
Where is the Discussion content... area?
Hi there,on the forums home page I saw Last post made in Discuss content..., but I can't seem to find it on the Active topics page.
2004-01-09
1 reads
Blogs
Enabling an Index: #SQLNewBlogger
By Steve Jones
I don’t do a lot of work with disabled index, but I learned how...
Back to Boston for SQL Saturday
By Steve Jones
I’m leaving again tomorrow for a trip. This time I head back to Boston...
T-SQL Tuesday #179: What’s In Your Data Detective Toolkit?
By Tim Mitchell
Most of us who work with data have, at least a few times, been...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers