peschkaj

function riak_dev_cleanup_stage() {
  for d in ~/Projects/riak/dev/dev{2,3,4,5}; do
    $d/bin/riak-admin cluster leave;
  done

  ~/Projects/riak/dev/dev1/bin/riak-admin cluster plan
}

function riak_dev_cleanup_commit() {
  ~/Projects/riak/dev/dev1/bin/riak-admin cluster commit

peschkaj

function riak_dev_cleanup_stage() {
  for d in ~/Projects/riak/dev/dev{2,3,4,5}; do
    $d/bin/riak-admin cluster leave;
  done

  ~/Projects/riak/dev/dev1/bin/riak-admin cluster plan
}

function riak_dev_cleanup_commit() {
  ~/Projects/riak/dev/dev1/bin/riak-admin cluster commit

peschkaj

using System;
using CorrugatedIron;
using CorrugatedIron.Models;
using CorrugatedIron.Util;
using ProtoBuf;

namespace TestAllowMult
{
    public class MainClass
    {

peschkaj

# -*- shell-script -*-

function riak_dev_cleanup_stage() {
  for d in ~/Projects/riak/dev/dev{2,3,4,5}; do
    $d/bin/riak-admin cluster leave;
  done

  ~/Projects/riak/dev/dev1/bin/riak-admin cluster plan
}

peschkaj

generated.cs is produced by Protobuf-net - you'll notice line 5's hilarious half-complete enumeration. This happens because CLR enums are value types and can't technically be null.

Corrected.cs contains my corrections on line 5. I think that this should let us get around these problems - it's good to know, though, because these do occur in a few other places in the protocol buffers interface.

peschkaj

SELECT * FROM Sales.SalesOrderHeader AS soh



CREATE INDEX jp_filters_not_offline 
    ON Sales.SalesOrderHeader (OrderDate) 
        INCLUDE (SalesOrderID)
        WHERE OnlineOrderFlag <> 0
GO

peschkaj

 SELECT QueryPlanHash,
        CASE WHEN QueryType LIKE '%Stored Procedure%' THEN 
             QueryPlan.value('declare namespace p="http://schemas.microsoft.com/sqlserver/2004/07/showplan";
                              sum(//p:StmtSimple/@StatementSubTreeCost)', 'float')
             ELSE  
            QueryPlan.value('declare namespace p="http://schemas.microsoft.com/sqlserver/2004/07/showplan";
                             sum(//p:StmtSimple[xs:hexBinary(substring(@QueryPlanHash, 3)) = xs:hexBinary(sql:column("QueryPlanHash"))]/@StatementSubTreeCost)', 'float') 
             END AS cost, *
  FROM #procs

peschkaj

Begin selectivity computation

Input tree:

  LogOp_Select

      CStCollBaseTable(ID=1, CARD=19614 TBL: Person.Address)

      ScaOp_Comp x_cmpEq

peschkaj

SELECT  qs.query_plan_hash ,
        query_plan.value('declare namespace p="http://schemas.microsoft.com/sqlserver/2004/07/showplan";
                             sum(//p:StmtSimple[xs:hexBinary(substring(@QueryHash, 3)) = xs:hexBinary(sql:column("qs.query_hash"))]/@StatementSubTreeCost)',
                         'float') AS cost ,
        query_plan.value('declare namespace p="http://schemas.microsoft.com/sqlserver/2004/07/showplan";
                            sum(//p:StmtSimple[xs:hexBinary(substring(@QueryHash, 3)) = xs:hexBinary(sql:column("qs.query_hash"))]/p:QueryPlan/p:MemoryGrantInfo/@SerialDesiredMemory)', 'float') AS serial_desired_memory,
        query_plan.value('declare namespace p="http://schemas.microsoft.com/sqlserver/2004
/07/showplan";
                            sum(//p:StmtSimple[xs:hexBinary(substring(@QueryHash, 3)) = xs:hexBinary(sql:column("qs.query_hash"))]/p:QueryPlan/p:MemoryGrantInfo/@SerialRequiredMemory)', 'float') AS serial_required_memory,
        *

peschkaj

WITH    rando
          AS ( SELECT   1 + ABS(CHECKSUM(NEWID())) % ( 4 ) AS RandomNumber
               FROM     master.dbo.spt_values sv
               WHERE    sv.type = 'P'
                        AND sv.number < 4
             )
    SELECT  r.RandomNumber ,
            d.number
    FROM    rando AS r
            INNER JOIN master.dbo.spt_values d ON r.RandomNumber = d.number