Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tag range Rss

   Items 1 to 3 of 3   

Fun with OVER

By Barry McConnell 2014/06/26 | Category: over
Rating: (not yet rated) |  Discuss |   Briefcase | 2,029 reads

Building Ranges using T-SQL

We often use excel for any running repetitive calculations since it is a very convenient user friendly interface which allows us to just enter a formula in a cell and simply drag and drop the formulas to generate a complete output.   Read more...
By Additional Articles 2011/12/16 | Source: SQL Server Performance | Category: t-sql
Rating:  Rate this |   Briefcase | 7,414 reads

Object Explore

summary information and metrics for any column in a given Table/View. Metrics include: number of records, distinct records, nulls, min, max, std, quartiles, kurtosis, skew, etc.  Read more...
By Robin van Schaik 2010/08/24 | Source: | Category: data exploration
Rating: |  Discuss |   Briefcase | 1,039 reads
   Items 1 to 3 of 3   
columns (1)    
data exploration (1)    
framing (1)    
kurtosis (1)    
metadata (1)    
metrics (1)    
over (1)    
quartiles (1)    
rows (1)    
skew (1)    
standard deviation (1)    
statistics (1)    
t-sql (1)