Skip to content

Instantly share code, notes, and snippets.

@Doogie04
Doogie04 / ExecutionPlan - Using Hint
Created October 15, 2012 17:18
SQLPlans (with/without) HINT - for dba.stackexchange.com question.
<?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="11.0.2100.60" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
<BatchSequence>
<Batch>
<Statements>
<StmtSimple StatementCompId="1" StatementEstRows="9.41114" StatementId="1" StatementOptmLevel="TRIVIAL" StatementSubTreeCost="0.00331306" StatementText="SELECT * FROM [TimelineMaterialized] [TM] WITH(noexpand) WHERE [TM].[EmployeeID]=@1 AND [TM].[CultureCode]=@2 AND [TM].[CreateUTC]&gt;@3 AND [TM].[CreateUTC]&lt;@4" StatementType="SELECT" QueryHash="0x1049C20BCA758A9" QueryPlanHash="0xC090D5386FCF0C62" RetrievedFromCache="true">
<StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" />
<QueryPlan DegreeOfParallelism="1" CachedPlanSize="32" CompileTime="151" Comp
@Doogie04
Doogie04 / 1.js
Created August 1, 2012 21:28 — forked from mxriverlynn/1.js
revisiting event aggregator
MyApp = {};
MyApp.vent = _.extend({}, Backbone.Events);
MyApp.vent.on("some:event", function(){
//do stuff common to ALL events
//usually you won't have logic here
});
var ObservingModel = Backbone.Model.extend({