Ok Thanks Alan. I do get the error when I comment out Recompile.

I ran the code from Eirikur on 2014 instance and did not receive an error.

Nice article. I tried it out for 2 puzzle. 1 "extreme" puzzle and looks like SQL has bug. Or I messed up the numbers but looked over it...

This is good stuff! Thanks Luis for sharing.

Hey Jeff,

I created a script that will store statistics of a stored procedure which has a parameter. This parameter has 9k distinct values that can be used.

So...

Thank you Luis and Scott!

What if you filter the records first before CROSS APPLY?

select

stockNew.stock_nbr_ky as stock_nbr_ky_new,

stockOld.stock_nbr AS from_stock_nbr,

stockOld.item_desc AS from_stock_desc,

stockOld.unit_price / stockOld.ui_conversion_factor AS from_stocking_ui_price,

stockNew.stock_nbr AS to_stock_nbr,

stockNew.item_desc AS to_stock_desc,

stockNew.unit_price / stockNew.ui_conversion_factor AS to_stocking_ui_price,

stockNew.pgm_id,

stockNew.lst_tran_dt_tm AS as_of_dt_tm,

stockNew.lst_updtd_by...

Yes all these triggers does make it hard to debug. Change Data Capture could be worth looking into.

Also I noticed in the instead of trigger, the code is on/off...

I think the output clause might work for you.

http://msdn.microsoft.com/en-us/library/ms177564.aspx"> http://msdn.microsoft.com/en-us/library/ms177564.aspx

Triggers

Columns returned from OUTPUT reflect the data as it is after the INSERT, UPDATE, or DELETE statement has...

This might help get you started. I am no expert at XQuery and there are probably better ways to do this.

declare @xml xml

set @xml =

'<EventOne ID="55" >

<EventDate>09/22/1984</EventDate>

<PartyID2 InternalPartyID="2">90</PartyID2>

<PartyID2 InternalPartyID="4">100</PartyID2>

<PartyID...

freddyism00 (9/12/2014)

---

hm ok, but why is it then said that columnstore indexes are "in-memory" ??that confuses me..

I read part of the whitepaper, it said the data columns are stored...

Sean Lange (8/27/2014)

---

That is pretty...

Yes actually that is behavior I have seen as well when an aggregate is used in the query.

In order to eliminate the NULL values you will need to group the...

Not sure if this is what you are looking for. This is assuming OrderID is the correct order you want.

SELECT TaskID

,TaskDate

...

You also might want to try casting every column in the query as VARCHAR. Then insert into a temp table/physical table to see if any value in a column...