TheSQLGuru (4/18/2016)

---

ScottPletcher (4/18/2016)

---

THAT IS...

Yeah, definitely not 'sa' or some other existing/standard user.

Create a new user, native SQL user will do if that's available to you, and grant it just the specific permissions it...

THAT IS A HUGE...

TheSQLGuru (4/15/2016)

---

ScottPletcher (4/15/2016)

---

TheSQLGuru (4/15/2016)

---

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)...

And I believe it...

TheSQLGuru (4/15/2016)

---

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...

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 this:

where...

Triggers should always be written for best efficiency first, even if it makes them harder to understand, especially so in your situation, with such heavy usage.

To keep each trigger as...

If you just want the static result of a function call to be inserted to the table, use INSERT INTO ... SELECT rather than INSET INTO ... VALUES:

INSERT INTO tblDashboard...

No, I don't know what would have added those indexes. But I also don't see the relevance of that. Wouldn't normal index analysis -- of missing index stats,...

I think it's a bad idea to assume the existing physical design is correct (unless you know that it was modeled very carefully logically first and then the physical design...

Or, since we're dealing with JOINs:

What is the difference between INNER JOIN and LEFT OUTER JOIN?

What is the difference between LEFT OUTER JOIN and RIGHT OUTER JOIN?

What is a FULL...

Yep, exactly. It sounds like some type of certification q too, where because MS mentions "restricted" in BOL or some other help, you're supposed to remember it exactly and...

Is that really necessary? Do you re-index all tables or just those that really need it? Hopefully you don't...

If the incoming data is sorted in clustering key order, you can add an:

ORDER ( { column [ ASC | DESC ] } [ ,... n ] )

clause to the...