And for anyone who searches up your question in the future and wants to know how you solved it, what was it?

No. You shouldn't hit any performance hits while doing it, but, the bigger concern for me is that between setting it to single user mode and continuing on with the...

The details are going to vary for your environment, but here's roughly how we used to do it:

1. Get a copy of the production backup

2. Restore it to a test...

It means you have more than one BEGIN statement and only one COMMIT or END statements. You need to have matching pairs for the query to work correctly.

TheGreenShepherd (2/14/2014)

---

Yeah, I know, it's non-SARGable. That was really my last line of defense for shooting this idea down, because his next suggestion is to make that column non-nullable, and...

It's all about speed. When you need really fast OLTP processing, you go with the in-memory tables and the compiled procedures. The limitations are too severe for any small or...

Michael Valentine Jones (2/14/2014)

---

I am not sure what "overnormalized" even means, but anytime...

Yeah, it could, although you might be better off creating the index on the table after you load it.

It sure sounds to me like the query could be tuned, but as to the long running stuff, I'd assume contention on resources. While it's running, have you collected wait...

Everything Kevin said, then check out the execution plan to understand where the indexes are getting used and where they aren't. Just tossing them vaguely towards a query never works...

This stuff is likely killing your performance too. It can't use indexes

DATEPART(dw, d.GREGORIANDATE) <> 1 AND DATEPART(dw, d.GREGORIANDATE) <> 7'

I've done this using both T-SQL and PowerShell, but the trick is, you have to be able to set up access to a common location. If you can't do that,...

Generally, this is when you go to your backups and restore the database to a point in time prior to the problem.

Evil Kraig F (2/13/2014)

---

Grant,

My understanding was the short circuit capabilities of the CASE statement would improve performance, but in a limited variety.

Instead of a simple data change on the table...

Recompile will override, yes. You can't really see query hints through the execution plan. You can see them in the SQL text that is stored with the plan.