PHYData DBA (4/29/2014)

---

paul.goldstraw (4/29/2014)

---

PHYData DBA (4/29/2014)

---

shanjan.sapra (4/29/2014)

---

Nice question. But I guess the another answer is also true as an Another alternative to enable/disable the different CE algorithms is the usage...

PHYData DBA (4/29/2014)

---

shanjan.sapra (4/29/2014)

---

Nice question. But I guess the another answer is also true as an Another alternative to enable/disable the different CE algorithms is the usage of a trace...

Yep, it left a bit to the imagination. Sadly I imagined wrong. If In-Memory wasn't relevant it really shouldn't have been mentioned because the question came across like it was...

I don't understand. I chose the last option, 'Alter all queries to use the trace flag 9481', which this page says will force use of the old version 70 optimiser....

Also if I paste either result into Notepad GO is on the same line. I had a feeling this would happen, but had no idea the engine wouldn't care for...

Thanks Jeff, makes sense. If someone asked me to right justify some text I think the quicker solution would be closer to what I would have attempted anyway as i'm...

Sorry if I'm just being dense by asking this, I've never used STR() either so this is new to me. The article says many people use STR() for its ability...

With regard to the badges themselves, our badges used to contain the company logo etc on them, in addition to the person's name and photo. Now they just contain the...

I'm firmly on the side of this sort of thing not being being something you can patent. Patenting the means to snip, maybe. Patenting what has been snipped, no. That...

I have none 🙁

Feel free to send me one though 🙂

Cheers

Paul

I think it's a terrible system. This means you could have a room full of the best and brightest, all of whom would be a '5' in a random sample...

Gail,

Thanks for elaborating on the complexities of this issue. I do appreciate any resolution that I would class as a fix would have negative side-effects as parameter sniffing is,...

Eugene Elutin (3/7/2012)

---

GilaMonster (3/7/2012)

---

paul.goldstraw (3/7/2012)

---

However, I don't consider this, or any of the other solutions online to be true solutions. A real solution would be code that just works....

Lynn Pettis (3/6/2012)

---

Just food for thought. If the procedure(s) have been working well for months (or longer) and then suddenly start having issues, it could be a result in...

Eugene Elutin (3/6/2012)

---

Are you allowed...