Steve Jones - SSC Editor (8/16/2016)

---

Brandie Tarvin (8/16/2016)

---

Has anyone here used GitHub?

If so, what did you think about it? Was it helpful? Was it annoying? Any caveats I should be...

Indianrock (8/8/2016)

---

I see two other similar plans in the cache with a high number of executions/uses and quick runtimes. This bad boy has only one use and slow runtime....

cmullen77 29296 (8/11/2016)

---

Well I had no idea that a trigger would fire even if nothing is inserted/updated...

I modified the trigger to verify that SOMETHING was inserted before proceeding...

The Dixie Flatline (8/16/2016)

---

Interesting discussion, but I am concerned about the casual dismissal of the number of logical reads. A consequence of more logical reads is that, in...

Brandie Tarvin (8/16/2016)

---

Has anyone here used GitHub?

If so, what did you think about it? Was it helpful? Was it annoying? Any caveats I should be warned about?

We're apparently getting it...

ben.brugman (8/16/2016)

---

The question was:

So how would you load/parse/store the data were all unnecessary data is filtered out before it is inserted ?

Given are the CSV files.

No additional Meta data is...

yujinagata72 (8/16/2016)

---

Hi,

If I have an SQL statement, I would like to get the estimated query plan in XML file without SSMS or SQL profiler, is that possible? The scenario is...

twin.devil (8/16/2016)

---

ChrisM@Work, +1.

But if you still interested to use your own code then you just need to convert the NVARCHAR(MAX) when assigning it to @SQL4. Here is the updated query:

--...

What are the REPLACEs there for?

declare @modelid nvarchar(50)= '68eeb617967eb2e685692486239128ff'

DECLARE @SQL4 NVARCHAR(MAX)

,@DynamicList4 NVARCHAR(MAX) = '';

SELECT @DynamicList4 += ',['+powerunit_natlang+'] = MAX(CASE WHEN powerunit_natlang = '''+powerunit_natlang+''' THEN a.value_primary ELSE ''''...

jesijesijesi (8/13/2016)

---

Hi Guys,

Sorry to post this in 2014 forum, I did that because the problem seems to be fixed in the new cardinality estimator.

I am trying to fix a performance...

Steve Jones - SSC Editor (8/15/2016)

---

ChrisM@Work (8/15/2016)

---

Someone was a little overzealous with spam removal over the weekend. On Saturday morning there was a new thread entitled something like “Hash match...

Steve Jones - SSC Editor (8/15/2016)

---

ChrisM@Work (8/15/2016)

---

Someone was a little overzealous with spam removal over the weekend. On Saturday morning there was a new thread entitled something like “Hash match...

ThomasRushton (8/15/2016)

---

It depends. (sorrynotsorry).

Where are you?...

Gosh never mind the telly, where's the best curry around here?

Someone was a little overzealous with spam removal over the weekend. On Saturday morning there was a new thread entitled something like “Hash match estimates miles out”. The OP had...