Transact-SQL Cookbook

sample size , statistics  

sample, statistics  

scalar values, multiplying matrices by  

schedules example, temporal data  

scores, importing example  

SELECT DISTINCT statement  

SELECT statement

       differences and  

       sets and  

SELECT TOP statement  

selective reduction, duplicates  

self-joins

       folding data  

       values  

sequences, lists   2nd  

sequencing properties

       Pivot table queries  

server push  

service information, hierarchies  

set operations  

       complements  

       contains  

       differences  

               recipe  

       intersection  

       unions  

sets  

       classes, summarizing  

       comparing  

       complement

               different universe  

               finding, recipe  

               missing set  

               size, recipe  

        components  

       defined  

       DELETE statement  

       elements  

       N values recipe  

       SELECT statement  

       Students example  

        subsets , classifying  

       subtracting

               one from all others  

               one from another  

       universes  

               comparing  

       UPDATE statement  

severity levels

       defining  

       logs  

SMALLDATETIME datatype  

       instants  

snapshots

       generating  

       logs  

       restricted  

space, audit logs  

specialized hierarchies  

SPSS statistics package  

stacks  

       implementing  

       indices  

standard deviation, statistics  

       calculation, recipe  

       expanding  

standard error of the mean, statistics  

standard error, statistics  

       calculation, recipe  

statements

       BULK INSERT   2nd  

       DELETE, lists  

       INSERT, lists  

       SELECT DISTINCT  

       SELECT TOP  

statistical median  

statistics

       arithmetic mean  

       autocorrelation  

       averages

               exponential  

               moving averages   2nd  

               weighted averages  

       basics  

       case  

       concepts  

       confidence intervals  

               building, recipe  

       correlation

               calculating, recipe  

       correlation coefficient  

       cross-sectional data  

       degrees of freedom  

       financial median  

       GNU R and  

        light-bulb factory recipe  

       mean  

               recipe  

       median  

               calculating, recipe  

       mode  

               recipe  

       patterns  

       population  

       sample  

       sample size  

       SPSS package  

       standard deviation  

               calculation, recipe  

               expanding  

       standard error  

               calculation, recipe  

       standard error of the mean  

        time-series data  

       value  

       variance  

               calculation, recipe  

status attributes, permissions  

STDEV function  

STDEVP function  

stepping through hierarchies recursively  

stored procedures

       buffer tables and  

       BuildProjectPathsRecursive  

       event logging  

       EventMessage  

       importing and  

       TraversProjectsRecursive  

       validation, importing and  

strings, integers  

Students table, sets  

subprojects , children  

subqueries, differences and  

subsets, classifying  

subtasks  

subtracting sets

       set from all other sets  

       set from set  

subtrees, hierarchies  

SUM function  

summarizing aggregated classes  

summarizing set classes