During my investigation on this question, I came across documentation on the FileTableRootPath function. "It...

Jacob

(y) Boots

("The Strange Tale of the Crack Fox")

Sean Lange (5/6/2014)

---

bkmsmith (5/6/2014)

---

Here is another option.

create table abc_test

(

id int

,runs int

,date1 datetime

)

;

insert into abc_test

(

id

,runs

,date1

) values

('24','1','2013-12-05 10:00:01.000'),

('24','2','2013-12-05 10:00:02.000'),

('25','1','2013-12-05 10:00:03.000'),

('25','2','2013-12-05 10:00:04.000'),

('25','3','2013-12-05 10:00:06.000'),

('26','1','2013-12-05 10:00:07.000'),

('26','2','2013-12-05 10:00:08.000'),

('27','1','2013-12-05 10:00:09.000')

;

SELECTT2.id

, [runs] = T2.MaxRuns

, T1.date1

FROMdbo.abc_test T1

INNER...

Here is another option.

create table abc_test

(

id int

,runs int

,date1 datetime

)

;

insert into abc_test

(

id

,runs

,date1

) values

('24','1','2013-12-05 10:00:01.000'),

('24','2','2013-12-05 10:00:02.000'),

('25','1','2013-12-05 10:00:03.000'),

('25','2','2013-12-05 10:00:04.000'),

('25','3','2013-12-05 10:00:06.000'),

('26','1','2013-12-05 10:00:07.000'),

('26','2','2013-12-05 10:00:08.000'),

('27','1','2013-12-05 10:00:09.000')

;

SELECTT2.id

, [runs] = T2.MaxRuns

, T1.date1

FROMdbo.abc_test T1

INNER JOIN

(

SELECTid

, [MaxRuns] =...

Hugo Kornelis (5/1/2014)

The TechNet documentation quoted above describes the ideal behaviour of optimizer + execution engine. It even explicitly says so: "the query optimizer assigns these roles so that the...

gbritton1 (5/1/2014)

---

Before I answered this question, I read

It reads, in part:

The hash join has two inputs: the build input and probe input. The query optimizer assigns these roles so that...

+1

This is the link that I referenced when researching this QOTD, and found it very informative.

Thanks for another great...

patrickmcginnis59 (8/2/2012)

---

bitbucket-25253 (8/2/2012)

---

I am rather surprised at the low percentage of correct answers.

And the implications this could have to...

sestell1 (6/25/2012)

---

mtassin (6/25/2012)

---

sestell1 (6/25/2012)

---

I was always under the impression that there was no reason to create indexes on table variables because they exist only in memory.

Does anyone know what SQL...

I could completely relate to the comment in the article that 'job titles held no meaning for him'. Given that I have been working as a 'technical consultant' for the...

I would most likely not be interested in live/video content. I predominantly consume the articles, scripts, and editorials, and have found these resources to be worthwhile. Browsing through the forums...