Skip to content

Instantly share code, notes, and snippets.

<?xml version="1.0" encoding="utf-16"?>
<ShowPlanXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Version="1.2" Build="12.0.4436.0" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
<BatchSequence>
<Batch>
<Statements>
<StmtSimple StatementCompId="1" StatementEstRows="60.0079" StatementId="1" StatementOptmLevel="FULL" CardinalityEstimationModelVersion="120" StatementSubTreeCost="1034.33" StatementText="select &#xD;&#xA; od.[Year], &#xD;&#xA; AvgValue = avg(ObservationValue)&#xD;&#xA;from dbo.ObservationDates od&#xD;&#xA;join dbo.v_Observation o&#xD;&#xA; on o.ObservationDateKey = od.DateKey&#xD;&#xA;where &#xD;&#xA; od.[Year] &gt;= 2000 and od.[Year] &lt; 2006&#xD;&#xA;group by &#xD;&#xA; od.[Year]&#xD;&#xA;option (querytraceon 4199)" StatementType="SELECT" QueryHash="0xE01A45FFCD2D134E" QueryPlanHash="0x9EFEF831BB146D" RetrievedFromCache="false">
<StatementSetOptions ANSI_NULLS="true" ANSI_PADDIN
@billinkc
billinkc / R notes
Created March 5, 2014 15:48
R notes
Get it
http://www.rstudio.com/ide/download/desktop
http://en.wikipedia.org/wiki/R_(programming_language)
In R, the widely preferred assignment operator is an arrow made from two characters "<-", although "=" can be used instead.
Set up
install.packages('ggplot2')
install.packages('RSocrata')
Lurning
@ttezel
ttezel / gist:4138642
Last active March 24, 2024 03:24
Natural Language Processing Notes

#A Collection of NLP notes

##N-grams

###Calculating unigram probabilities:

P( wi ) = count ( wi ) ) / count ( total number of words )

In english..

Redis + LibUV prototype README

Special thanks to Dušan Majkic (dmajkic, https://github.com/dmajkic/redis/) for his project on GitHub that gave us the opportunity to quickly learn some on the intricacies of Redis code. His project also helped us to build our prototype quickly.

Get source repository

First clone the Redis sources from https://github.com/antirez/redis.

  • On your computer create a working folder and cd into it.
  • Clone antirez/redis repository: