river1 (9/16/2016)

---

In terms of index strategy, should I create one index for mch.market_code and another for mch.audit_procedure_result_id or it is better to have a index that is composed by...

What does the PLE look like over a day or more?

ken.trock (9/15/2016)

---

This should return an error. For me it simply returns no rows. If you look closely I fat fingered the creation of dbo.EH_NativeWorker_Dups. Maybe the compiler/parser got confused because...

Good start

What's the most common predicate used against that table?

What's the table frequently filtered by?

I submitted an abstract, but it was turned down, so no (and frankly I'm just about travelled-out this year)

You're welcome.

Yes, it's the cost of the serial plan that's subject to that limit. If, as the optimiser was generating the plan, the serial plan it considered had a cost of...

Rather run the patch and let it manage the instance for you. Patches often contain T-SQL that has to be run in addition to the binaries changes.

If you absolutely insist...

Be...

exec sp_rename ???

Dropping all the indexes and recreating them will take ages, and do massive IOs and bloat the transaction log.

SQL 2008 R2 database engine? (run SELECT @@Version please)

What version of Management Studio? (Help -> About, attach a screenshot please)

If that's the only purpose, and it's for 6 months, can you just do the edition upgrade and leave the DB server on 2008?

You won't be gaining much from...

One thing first, why upgrade to a version that's completely out of support and has barely any changes or improvements over what you're using? If you're upgrading, why not *upgrade*?

SQLAudit should be able to do that.