You probably want to verify that the dates are actually backwards before swapping them:

update tableA

set StartDate = EndDate,

...

Can you give any example of where converting a literal value to appropriate non-unicode literal could ever cause SQL a performance issue?

Or for dates. Our rule is you convert...

chuck.forbes (4/18/2016)

---

Are you saying that I should put this restore-capable user account into the db_owner role for the database? I haven't heard of making someone a dbo user (I always...

TheSQLGuru (4/18/2016)

---

Completely disagree with the first sentence. And even more...

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