Thank you for the question.

I agree that the constant prefix .com is strange, but if that is documented as it is maybe in a later version...

Nice spot, I never used it.

Does anyone have a scenario when to use it?

T.a.

Yes, learned something today. Thanks for spoting this.

Stewart "Arturius" Campbell (4/4/2016)

---

Good question, thanks Steve

Iulian -207023 (4/4/2016)

---

Nice question, thanks for sharing it.

I am curious if I can make a synonym for an object on a linked server.

Any idea...

Thanks a lot Joel, good spot. Connecting to other db provider as it would be...

Nice question, thanks for sharing it.

I am curious if I can make a synonym for an object on a linked server.

Any idea ?

It seems to be a trace flag that pushes parallel processing.

Check this out: forcing-a-parallel-query-execution-plan

I basically understand that:

We can make a query to get an execution plan that uses parallel...

Stewart "Arturius" Campbell (3/31/2016)

---

Nice one, thanks Peter

Remember, if you do not specify that a PRIMARY KEY is NONCLUSTERED, it will be created as CLUSTERED (i.e. logically ordered). However, the order...

as per msdn: https://msdn.microsoft.com/en-us/library/ms189039.aspx

"You...

Carlo Romagnano (3/31/2016)

---

Iulian -207023 (3/30/2016)

---

Nice question.

But why 2 on this assignment?

SELECT @SelectVariable = ID

FROM @Table

Since they were inserted in as 0,2,1 the last value would be expected to be...

Nice question.

But why 2 on this assignment?

SELECT @SelectVariable = ID

FROM @Table

Since they were inserted in as 0,2,1 the last value would be expected to be 1, like in a...

Yes, interesting question. Thanks.

Nice trick, it-s safe to add the missing columns before insert.

Thanks for sharing.

Iulian

Good question, learned something today.

Iulian

Luis Cazares (1/29/2016)

---

Iulian -207023 (1/29/2016)

---

Jacob Wilkins (1/29/2016)

---

From https://msdn.microsoft.com/en-us/library/ms186775.aspx, under "Remarks":

For a given identity...