I can appreciate your point of view. Thanks for sharing.

Toby White (4/2/2010)

---

I am not sure how I arrived at the above statement because what I meant to say was that if it were parameter sniffing the performance would have...

Take a breath, David. It's only a forum, and people are allowed to hold differing views...:laugh:

It concerns me that you seem to have taken it all very personally...and...

Agreed. Good questions often spawn this sort of interesting exchange of views. Once of the reasons I...

Heh, so I passed? 😉 😎

Web Edition doesn't support ONLINE, no.

I always prefer to rebuild OFFLINE where I can anyway 🙂

Not aware of any scripts, but I have asked Michelle if she has any plans...

Yes that's a much better way of putting it - happy with that.

Otherwise, people might erroneously infer that a Gather...

vaibhav.tiwari (4/2/2010)

---

Now what should i do for null values in result set as those are also dates not the garbage data.and i have to do some date operation on those...

You asked for feedback in your original post and, as far...

Synonyms were created to meet exactly the sort of need presented here.

They are easy to define, and avoid...

carl.anderson-1037280 (4/2/2010)

---

I see. So if you want to remove the full set of 37 unprintable characters, you would have to create 37 levels of nesting with REPLACE. I...

Toby White (4/2/2010)

---

Parameter sniffing is the process whereby the optimizer uses the initial values of the parameters to generate an optimal execution plan. One of the problems can occur when...

One potentially efficient approach revolves around the fact that you are deleting 85% of the data.

That must take a while, and then you have the shrink operation too...

I would be...

You are assuming that...

I caught trigger definitions in one once 🙂