Thanks.

They have quite a broad definition:

The following system functions perform operations on and return information about values, objects, and...

free_mascot (6/29/2015)

---

Thanks Shiva.

It would be good if more context have been used. As ROW_NUMBER and DENSE_RANK is "Ranking Functions", DATEADD and CURRENT_TIMESTAMP is "Date and time function". Now NEWID is...

Interesting question, thanks.

A bit more context could have been useful, as others have pointed out.

Thanks for the question.

lskidgel (6/25/2015)

---

"Ahhh...well it just sounds like you need to just repeat the header. Should be an option to do just that. "

Not sure what you mean by that, but no,...

Grant Fritchey (6/25/2015)

---

SQLBill (6/25/2015)

---

Grant Fritchey (6/25/2015)

---

SQLBill (6/25/2015)

---

Okay, so how many looked at the cat and then looked at the books and thought "I...

We're in the last stretch of 1,000 posts before the thread reaches 50,000 posts. What a milestone 😀

Easy one, thanks.

Would it be an option to just create two different queries?

My first guess is that all the execution plans have to be compiled again, and that maybe there is no caching at first.

Hugo Kornelis (6/24/2015)

---

The examples in this question are actually quite common. They are very often posted in the ever-returning discussion on EXISTS (SELECT * ...) vs EXISTS (SELECT 1 ...)...

Easy one, thanks.

Easy one, thanks.

Nice one, thanks.

Try to find the execution plan of the query for both applications. Chances are they are different.