Lynn Pettis (4/15/2016)

---

Just one thing I saw:

case

...

I haven't tried it, but I wonder what happens when you do this and then create something on the Enterprise-edition...

The file for that single query is 6.5KILOBYTES!! I have spent a dozen or more hours many times the past trying to decipher and fix stuff like that at clients....

ScottPletcher (4/15/2016)

---

The simplest rules is:

Never use ISNULL in a WHERE or JOIN clause.

Whether the column is nullable or not is irrelevant.

The proper way to code this:

where isnull(SalesOrderID,-1) = 43665 --NEVER!!

is...

Hugo Kornelis (4/15/2016)

---

TheSQLGuru (4/15/2016)

---

Wrapping a function around a column in the WHERE clause is probably the second worst thing I see in aggregate in my consulting (with the first being...

<RANT ON>

Wrapping a function around a column in the WHERE clause is probably the second worst thing I see in aggregate in my consulting (with the first being mismatched...

Stop allowing users to modify the schema of a table via a GUI. This MUST be a CONTROLLED evolution for numerous reasons, including the one that is giving you fits.

1) Buy better hardware? How much RAM do you have and what is the throughput you get from your IO subsystem for a large scan?

2) I usually recommend for my...

SQL 2016 has a LOT of wins, but I don't know of one here for you. You can now do a "Basic Failover Group" on Standard Edition, but it is...

Grant Fritchey (4/14/2016)

---

Jeff Moden (4/14/2016)

---

That's what I thought, as well, but even on the predominately "batch-needs-scans" databases, performance hasn't suffered. Heh... of course, that could be because that code...

Jon.Morisi (4/14/2016)

---

Mirroring does not allow for readable secondary.

In order to read the secondary for log shipping you'll have to enable STANDBY mode and there's potential that users will...

Lynn Pettis (4/14/2016)

---

Sean Lange (4/14/2016)

---

Those nested views are going to kill your performance something fierce. They...

Like I said, I would rather see the code of the UDF and the objects it hits more than the query plan in this (very rare) case since when you...

When you reply to the thread, check the lower-right of the window. Button called "Edit Attachments".

Jeff, the next time you and I are together FTF (SQL Saturday or PASS Summit?) we need to have a long, detailed talk about the things you state below. I...