SQLMark2012 (1/5/2016)

---

Ok, I opened Visual Studio 2013

File > New > Templates ...

and yes, no "Business Intelligence" and hence no "Integration Services Project"

following that, per your suggestion I went out and...

Very slick Chris.:-)

I'm buried today but will play with this later tonight and report back.

Go to File > New >

then...

Templates > Business Intelligence > Integration Services Project

If...

Rich Mechaber (1/5/2016)

---

Alan.B (1/4/2016)

---

Except for recursive CTEs, CTEs and Subqueries are basically the same thing. I prefer CTEs for a couple things:

First, for nested queries. CTEs make nested queries much...

I created a new thread...

Nobody said that...

Eirikur Eiriksson (1/4/2016)

---

Alan.B (1/4/2016)

---

I agree with this 99.9999% of the time...

winkl (1/4/2016)

---

Thanks for the article, Mickey.

Have you tested your scalar UDF using schemabinding? We're testing that now to see if we can bring some of the cost...

erics44 (1/4/2016)

---

Alan.B (1/4/2016)

---

Except for recursive CTEs, CTEs and Subqueries are basically the same thing. I prefer CTEs for a couple things:

First, for nested queries. CTEs make nested queries much more...

If the FTE salary for my area is $130,000 to $140,000 for a senior level DBA, that would be about $65 (W2) per hour based on 2,000 hours per year....

patrickmcginnis59 10839 (1/4/2016)

---

TheSQLGuru (1/4/2016)

---

lucien.jacquet (1/4/2016)

---

My point is not to contradict your assertion that scalar functions "can be" expensive, but to suggest that your example is a worst-case scenario. Is it...

I've been busy 😉

Except for recursive CTEs, CTEs and Subqueries are basically the same thing. I prefer CTEs for a couple things:

First, for nested queries. CTEs make nested queries much more readable and...

I agree with this 99.9999% of the time but I did...

You can also take a peek at this:

http://m.sqlmag.com/t-sql/avoid-unnecessary-lookups-when-using-rownumber-paging