All kinds of issues here:

1) I assume this is testing BEFORE upgrading, right? That way you don't have production issues that could have been avoided. It irks me to no...

carl.thompson (11/22/2016)

---

Hi SSCrazyEights,

Thank you for your reply.

That makes perfect sense and I think confirmed what we thought to be the reason for the inclusion in the function. Can...

What, exactly, do you need to do with the data returned that makes you not want the column names?

Is your app telling your queries to parameterize, i.e. do they look like this in Profiler:

exec sp_executesql ...

If they do and you default everything this is what will happen -...

You are worried about the wrong thing. Setting MAXDOP to number of physical cores in a NUMA node is more for attempting to ensure you maximize local memory access and...

IIRC, HASHBYTES isn't very good for your purposes. I think Thomas Kejser did a very good analysis of various mechanisms for computing unique "checksum" type values. You should be able...

Assuming you can guarantee that that 1-1000 update actually made it into the table with the trigger on it then the most likely scenario I can think of by far...

Take a look at Ola Hallengren's maintenance suite. I don't think it can do all you are looking for, but a) you should be using it anyway and b) you...

Sioban Krzywicki (11/17/2016)

---

TheSQLGuru (11/17/2016)

---

Need quite a bit more detail here to help.

Anytime code works sometime and not others you need to take a REALLY close look at the logic...

This isn't a SQL Server related problem, and we don't have access to your source code in any case. Post up on an appropriate forum. Or come up with a...

If there isn't some correlation between the tables just declare variables, get the max of each table separately then do a single query where id > max of other??

May...

Need quite a bit more detail here to help.

Anytime code works sometime and not others you need to take a REALLY close look at the logic and especially conditionals/predicates...

Most likely issue, other than you just coded things poorly, is security stuff.

What error is your process throwing if any? Is it running and doing nothing? Is the job...

Can't dig into it right now, but something tickles the back of my mind that you may be able to do this with just the CASE statement without the MAX/GROUP...

sindhupavani123 (11/17/2016)

---

Hi,

I have following data , numbers recruited/applied for a particular office, and would like to find the difference between previous and current year and their percentage increase or decrease.

Mentioned...