@PaulB-TheOneAndOnly

HTH!

So I guess that my next move is to google scrum! 😀

Very unlikely.

You can always post the actual execution plan, but I don't see this ever running fast.

You'll always scan the whole table and worst, make multiple pattern matches on the...

Cowboy DBA (9/20/2011)

---

Lowell (9/20/2011)

---

One of our developers started down that same road, because we had so many users familiar with Excel, but we ended up switching to a web page...

Massive difference is an understatement.

Unfortunately most of my tricks work on the basis of having the actual plan.

Hopefully Gail has a few more magic tricks she can share!

I tried all those tricks and frankly the one I preffer is to have implicit transactions on by default in all my ssms environements.

That way whatever you do has to...

Lowell (9/20/2011)

---

One of our developers started down that same road, because we had so many users familiar with Excel, but we ended up switching to a web page instead;

we...

steveb. (9/20/2011)

---

Ninja's_RGR'us (9/20/2011)

---

steveb. (9/20/2011)

---

wildh (9/20/2011)

---

Does anyone have experience of DSDM Atern? How generic is it? and why cant I find much/ anything about it with relation to Business...

steveb. (9/20/2011)

---

never used that...

Any reason why you ask this on a sql server forum which has a great BI suite?

Assuming you already tried googling for the product and found nothing. That says...

NJ-DBA (9/20/2011)

---

ah, where to start... skipping the conversation and questions about "testing" on "production", and assuming you know what you are doing....

one way to test is to pull the...

Please post both good & bad ACTUAL execution plans.

double post.

for at least another 100 posts :-D.

Kiara (9/20/2011)

---

Roy Ernest (9/20/2011)

---

Self plug...

This is a unique event where you can mix business with pleasure....

L' Eomot Inversé (9/20/2011)

---

Brandie Tarvin (9/20/2011)

---

GilaMonster (9/20/2011)

---

<pedantic>

CTEs don't start with a ';', no more...