Alan.B (12/9/2016)

---

Indianrock (12/9/2016)

---

I've heard this advice everywhere. Don't do things to change the way the sql optimizer produces plans etc. "it's smart so don't use plan guides, query...

Indianrock (12/9/2016)

---

"It’s not using new stuff because of FORCED parameterization because it caches the plan and reuses it. If you keep it SIMPLE, I think it would use the new...

nal4236 (12/3/2016)

---

SQL Enterprise licenses are only sold in the 2-core "pack", essentially what I'm referring to as a "single SQL Enterprise license" since you do not have the option...

Test carefully and see, and make sure you read up on them

Test carefully and see,...

Indeed you can only buy licenses in packs of two, as my...

Read committed snapshot or snapshot isolation?

You probably want a

WITH EXECUTE AS

on that proc for the insert into a table in master.

Do you have proper error handling that will rollback in case of an error?

I haven't specifically tested those, but there are no changes I know of to fix them in 2016. Stick with OPTION(RECOMPILE) on them.

From 2014 it should be a safe upgrade.

Not an article, but...

Query Store is probably the killer feature. It makes it trivial to monitor performance, track query plans, etc.

The "It just runs faster" series of posts on the...

Except that it won't show isolation level differences except for lock-based vs rowversion-based, because they're data modifications and hence aren't...

nal4236 (12/1/2016)

---

Yes, you need enough SQL Enterprise licenses to cover all 16 cores, however one SQL Enterprise license = 2 cores. So for a 16-core server you'll need a total...

Temp tables are logged in the default...

They're not hard to do.

Multiple identical selects in a transaction (maybe with a waitfor between them) and updates, inserts and deletes running from elsewhere that would affect rows returned by...

2005 can be *restored* to anything above it.

The two-version limit is in-place upgrades afaik. Restores there's no such limit (as long as you're not dealing with a SQL 2000 backup)