Good work! 🙂

Good tricky question!

😀

Yes, it is.

Sometimes, store procs run slow because of parameters sniffing and obsolete query plan.

If you recompile, store procs may run better.

Clear and easy question! Thanks!

🙂

It's...

Easy, if you know it.

Too much easy!

Thanks for TWO free points.

+1

sknox (10/1/2013)

---

Haven't had time to research SQL 2014 yet.

Guessed optimistically.

Got it wrong.

Can anyone explain why this should still be around when CLR has been available to replace its functionality since...

I think that extended procedures are unremovable, also, if Microsoft discourages their use.

Perfect qotd and explanation.

Thanks!

John Mitchell-245523 (9/26/2013)

---

I know it's a matter of preference, but I'd rather have any complexity tucked away in the CTE definition than in the body of...

No recursion needed to create a dynamic tally table with a CTE:

-- Code below is SQL Server 2008 or newer

with e1(n) as (select 1 from (values (1),(1),(1),(1),(1),(1),(1),(1),(1),(1))dt(n)),

...

Be aware of case:

DECLARE @STR VARCHAR(8000) = N'SELECT * FROM sys.objects'

EXECUTE SP_EXECUTESQL @STR

It should be:

DECLARE @STR VARCHAR(8000) = N'SELECT * FROM sys.objects'

EXECUTE sp_executesql

John Mitchell-245523 (9/25/2013)

---

Clearly not useless, even if your personal preference is not to use them. And no more or less complicated, in my...