Ed Wagner (9/12/2014)

---

Without objection, it is so ordered....

Lempster (9/12/2014)

---

I...

Motion passes with no objections.

Should be (and btw, that's not a temp table. It's a permanent table)

WITH TempCharges AS (

SELECT ChargeRef, PolicyRef, LastChargedDate,

CASE

WHEN Freq = 1 THEN 12

WHEN Freq = 2 THEN...

Columnstores aren't in-memory structures. They're disk-based.

Have you read all the whitepapers on columnstore? If not, hit google, a search for whitepaper columnstore finds them.

I'm sorry. I will schedule penance for the afternoon (documentation)

Ed Wagner (9/12/2014)

---

And just...

Please post table definitions, index definitions and execution plan.

Is that SELECT * really necessary or do you just need a subset of the columns?

Merge does.

Iulian -207023 (9/12/2014)

---

I found this, on msdn, it must be on a different context and that would explain it or it can be a typo as well, who knows...

Tell them that neither are required to test performance of their procedures.

EXEC sp_recompile 'ProcedureName'

Meow Now (9/11/2014)

---

I was asked this very thing in an interview a while back. Except, they wanted to know if a TRUNCATE was fully or minimally logged. While I mentioned...

Um... http://www.sqlservercentral.com/Forums/Topic1612868-3411-1.aspx ????

It means that SQL cannot respond to OS requests to reduce its memory usage and hence, if the OS comes under memory pressure may result in SQL being swapped to...

That's fairly easy

SELECT e.Data AS ID, y.Data AS FiscalYear

FROM dbo.Split(@EmployeeID, ',') e CROSS JOIN dbo.Split(@fiscalyear, ',') y