DennisPost (6/9/2016)

---

Hugo Kornelis does a good write up of the overhead involved when calling an UDF and the bad decision taken by the query optimizer. A few big SQL names...

There must be some truth in this:

If Lowell's query returns no server triggers, then it's most likely that there were no server triggers at the time the backup was taken....

May be, may be not.

Hard to tell from here.

That's...

Sergiy (6/8/2016)

---

Luis Cazares (6/8/2016)

---

I mentioned that because he stated the following:

Now, even with the DISTINCT,...

Luis Cazares (6/8/2016)

---

I mentioned that because he stated the following:

Now, even with the DISTINCT, it...

Luis Cazares (6/8/2016)

---

There's something going on with your server. Taking 16 hours to complete a single query is insane.

We're assuming this is a table, but if it's a view, that...

And then was an instruction, right below the second part:

"run it altogether" means...

Here was the second part:

Here was the first part:

Sergiy (6/7/2016)

---

How long does it take to run this?

DECLARE @basedata table(

email NVARCHAR(200) COLLATE DATABASE_DEFAULT,

project_name VARCHAR(200) COLLATE DATABASE_DEFAULT

PRIMARY KEY (email, project_name)

)

INSERT INTO @basedata ( email, project_name )

SELECT...

david.jack (6/8/2016)

---

Hi - very grateful for any help:

I've got the same value 2306.7555 in 2 tables,both data type float. I'm comparing the values converted to 3 decimal, but for some...

colin.frame (6/8/2016)

---

This logic doesn't quite match what's given - the pm.pdenddate=pt.pdenddate part excludes all lines where one side only of...

IA123 (6/8/2016)

---

That took 46 seconds.

I tried select * from @basedata, but it didn't work. It says 'must declare the table variable @basedata'. I'm new to sql so apologies if this...

How long does it take to run this?

DECLARE @basedata table(

email NVARCHAR(200) COLLATE DATABASE_DEFAULT,

project_name VARCHAR(200) COLLATE DATABASE_DEFAULT

PRIMARY KEY (email, project_name)

)

INSERT INTO @basedata ( email, project_name )

SELECT email, project_name

FROM dbo.[UMG sent 2016]

WHERE...

jc85 (6/2/2016)

---

I have read through a few articles on stored procedure performance with parameters, variables and literals but still unable to understand why Parameters run faster than variables in the...

and NOT (pm.pdenddate=pt.pdenddate

OR (pm.pdenddate is NULL and pt.pdenddate is NULL)

)