Maxdop sets the limit for how many threads may be *running* at one time, not how many threads in total there are. So of those 17, at most 8 will...

I suspect that you will need to do this as three updates.

Autoshrink is one of the very few settings that should only every have a single value, no matter what the DB or system. False.

Why do you need to export/import to do a version upgrade?

No impact, though if you have monitoring tools looking at the wait stats they may get confused.

Personally I prefer not to clear it when doing analysis and just take diffs...

Is the performance problem blocking-related? If so, have you considered using one of the optimistic concurrency isolation levels? That's read-committed-snapshot isolation or snapshot isolation levels?

kevaburg (2/24/2015)

---

So I migrate a 2008R2 database to 2014 and do not alter the compatibility mode. I have in end effect a database running on a 2014 Server that...

julian.fletcher (2/19/2015)

---

So perhaps it's an initial call with @Mode = 1 (say) which was OK, followed by @Mode = 7 was was NG. If that's the case, we presumably just...

First, why do you need to shrink the log at all?

Second, no you absolutely do not have to change recovery model and you shouldn't. If you've got HA set up...

Other than better performance, the new features of SQL 2014 and a version which is under support and will get service packs and updates?

passiondba (2/23/2015)

---

I can write a query like below

insert into audittable ......(condition goes here)

delete from DupeChecktable......(Condition goes here)

But there is no guarantee that first insert happens and then...

Perfectly. To be honest, it's fairly safe (at least from SQL's side) to just power off without any form of clean shutdown (my home server will attest to that, having...

Kutang Pan (2/23/2015)

---

Bouke Bruinsma (2/23/2015)

---

I wouldn't dare questioning your or Gails remarks. But I could give many examples where a database is in full recovery mode without any backup strategy...

I can't answer that (not willing to be a lawsuit target)

Standard can be, iirc, licensed with server and CAL. Do the maths, CAL may be cheaper if you only have...

And...