aochss (8/9/2013)

---

Great question (I like that you included explanations of the build in function).

However, I cannot see the use/value of the "NULLIF" construct. In what situations would you...

Being mostly self taught in SQL Server, it has been more of a gradual slide into understanding, but I guess if I had to choose something it would come from...

Koen Verbeeck (8/8/2013)

---

Sean Lange (8/8/2013)

---

This whole English thing is the reason we American's don't know any other languages. All the others have actual rules that you follow all of the...

I would think that looking at the execution plans with 4 and 8 DOP would be a starting point.

Any chance that your tempdb setup is not optimised for MAXDOP 8?

That's not the only place this can happen of course...

ok181ko (8/8/2013)

---

How about

newid() = '00000000-0000-0000-0000-000000000000'

The question is not correct....

Yes, you get @@rowcount =...

Sean Lange (8/6/2013)

---

Lowell (8/6/2013)

---

no, you should say "Because @@rowcount is affected by any commands in the session, it's my practice to re-select from the table in case there was a...

Actually, yes you are right - that was imprecise of me - thanks for picking up on...

Amy.G (8/5/2013)

---

I am creating a table by using the

SELECT column1, column2

INTO NewTable

FROM OldTable

method. Is there a way of creating a table in this manner and saying if the columns should...

Of course the other problem with SET ROWCOUNT is that it could affect the outcome in unseen ways, restricting every query within the SP to the limited number of rows,...

Are you using a particularly slow system?

Millions of rows shouldn't be a major problem unless those rows are massively wide...for instance, on my PC I can shift 1000000 rows...

When you are asking for help it is useful to provide easily usable sample data like this:

declare @ins table(inscol xml);

insert @ins(inscol)

select convert(xml,'<?xml version="1.0"?>

<!DOCTYPE ins PUBLIC "ins" "hsdbdj">

<instructions>

<format-template>${ND}

</format-template>

<node id="node-0"...

Start here (MSDN link): Database Mail

If you get stuck come back and ask. 🙂

So, can you not check the values you are about to log and send email as appropriate from there?

SQListic (7/31/2013)

---

Hi Experts,

We do custom logging into a table. The requirement is that the developers should receive email immediately whenever there is specific data in that column

Any Input is Appreciated

Thanks...