Generally, the optimiser will try...

Yep. Same issue as for scalar/multi-statement TVFs, many remote operations, table variables, XML methods and so on: no statistics, and Microsoft don't (currently) provide a way...

All the stolen content seems to have been removed.

There is some comment on the action taken on the home page http://www.sqlblogs.net/

I'm glad this was stomped on so quickly - but...

Trey Staker (5/20/2010)

---

I thought about jumping in on that discussion, I even wrote something up then deleted it. The reality is that I don't have anything more to contribute...

Maa421 (5/20/2010)

---

Then do I need to enable AWE on my 64-bit SQL Server 2008 Std/64-bit Server 2003 Std R2/9GB RAM machine? I have read that this was enabled automatically....

Me and Gianluca standing up for what's right!!! LOL

Wait until Jeff sees that thread...he does not suffer anti-dynamic-SQL...

I see now - you guys are way ahead of me tonight.

Trying to do too many things at once, and failing to do any of them well!

CirquedeSQLeil (5/20/2010)

---

Paul White NZ (5/20/2010)

---

Chris Morris-439714 (5/20/2010)

---

Paul White NZ (5/20/2010)

---

Chris Morris-439714 (5/20/2010)

---

Paint...

There's a...

Yeah.

And congratulations.

tigriswoods (5/20/2010)

---

My question is this: does the order within the query matter? ie. does SQL Server work from left to right? and if so, would putting the parameter test...

Dynamic SQL - versus - not very dynamic DBAs.

Hey Chris, what's with the paint tin avatar?

A few posts ago:

http://www.sqlservercentral.com/Forums/FindPost924986.aspx

Jeff Mason-256568 (5/20/2010)

---

I edited the post above when I read Gail's blog, but even that isn't a great solution in toto once I started testing it. You CAN use...

I do take your point (hence the 4 stars) but that is still way too harsh.

I mean,...