Lynn Pettis (12/9/2009)

---

jcrawf02 (12/9/2009)

---

I have to say, jokes aside, I'm impressed with the group's psychic abilities, to be able to help someone with so little to work with. I...

To follow up on what Gail said, (and make it very obvious)

Declare @NewBody Varchar(100)

Set @NewBody = 'A record with id ' + d.id + ' has been updated'

--Note: Where...

Lynn Pettis (12/9/2009)

---

Anyone have a polite way of telling someone to learn how to debug their own code?

I'm trying to help, but any time I try to write something about...

Use the brackets [ and ].

Or click on the IfCode to the left that has code="sql" with the brackets.

Thus, the reason why it could...

There have been a few concerns regarding the moving of data to a different drive if you rebuild an index in a partition scheme.

I want to provide a scenario to...

That's good to know.

Gianluca Sartori (12/9/2009)

---

Wow! Thanks Gail, I'm trying immediately on my production server. :hehe:

Would you also recommend (as a fellow expert) turning on these switches?

exec...

Pleae read the articles provided in the urls posted to this thread.

You're welcome and thanks for the feedback.

GSquared (12/9/2009)

---

I had...

Oh boy, Gus just went there with the power button on that Lock question.

Dropping only provides limited emphasis (terminal...

Alvin Ramard (12/9/2009)

---

You mean the turbo button on the...

If you are referring to a server option for sql server to page memory out, you may want to read the below article. This is not necessarily a go...