pooyan_pdm (8/19/2016)

---

This is a "deprecated" feature, as per Thomas's post it not possible to replicate between 2016 and 2008 R2 and is not completely supported between all different versions,...

Brandie Tarvin (8/19/2016)

---

Congrats! Nice accomplishment.

Is this one...

!!!!

https://www.pluralsight.com/courses/identifying-fixing-performance-issues-caused-parameter-sniffing

And massive amount of work it was too. Recording's the easy part. Scripting is the most time consuming, editing probably the most difficult.

I'd go straight for 16. It's a good version, lots of new features that you may find useful (temporal tables, stretch DB, always encrypted, dynamic data masking, etc), and it's...

Consider tossing the sequence table away and using SQL's built-in sequence objects (in the product since 2012 iirc) once you get up to SQL 2014. They have the same mechanics...

I don't know why that warning sometimes appears. It might be the QO needs multi-column stats, which will not be manually created. I need to research that sometime.

I'd say nuke...

Citation needed.

MSDN does not list replication as a deprecated feature. Please reference your source for...

No and no.

BLOB_EATER (8/18/2016)

---

Grant Fritchey (8/18/2016)

---

BWA-HA-HA!

I was just having a conversation about statistics in...

Jeff Moden (8/18/2016)

---

I'm toying with the idea of just dropping all the stats that have the minor nuance in the name that I spoke of and letting the system sort...

Yup, but those column stats are usually very important (if they weren't necessary the optimiser wouldn't have had them created), and there's still the index stats on indexes that you're...

kramaswamy (8/17/2016)

---

Earlier in this thread, Grant suggested updating the statistics after an index rebuild was not the right approach, since the statistics are already updated by the rebuilding of the...

Since you're on 2014, open a case with product support.

I wouldn't do it that way round.

Index rebuild first, if necessary, afterwards update any stats that need updating.

A strongly recommend against doing the above. It'll work, but not well. The guidelines for adding partitions is to ensure that no data needs to move from one partition to...