SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Guest Columnist: Mala Mahadevan

SQLServerCentral.com profile

   Items 1 to 4 of 4   
 

Simpson's Paradox

This article is a case study and an attempt to explain an interesting phenomenon with data anomalies that is commonly called Simpson's Paradox.   Read more...
By Mala Mahadevan 2017/01/10 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 3,265 reads

Internal Query Processor Error with ColumnStore Indexes

SQL Server 2016 does not allow computed columns to co exist with columnstore indexes and clustered btree indexes on same table.  Read more...
By Mala Mahadevan 2016/12/29 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 527 reads

Basic Data Manipulation for Relational Data in R

In this post I will attempt to explore simple commands to manipulate data pulled in from a SQL database into R.   Read more...
By Mala Mahadevan 2016/10/20 | Source: SQLServerCentral.com | Category: r programming
Rating: |  Discuss |   Briefcase | 1,215 reads

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.  Read more...
Rating: |  Discuss |   Briefcase | 1,458 reads
   Items 1 to 4 of 4