In that case, it should be fine. Start with all SQL 2014 replicas in an AG and upgrade them one by one.

https://msdn.microsoft.com/en-us/library/dn178483.aspx

No (with caveat).

The root reason here is that databases cannot be downgraded, nor can log structures. So while it should be possible to have a primary replica on 2014 and...

Unless you had some custom monitoring, you're not going to get that.

You can query the plan cache (sys,dm_exec_query_stats cross apply sys.dm_exec_sql_text) to get the text and last execution time of...

I'd recommend extended events on 2012. Add in the QueryHash column and the aggregation is trivial to do in T-SQL, no need for string comparisons for ad-hoc queries any longer.

Identify the queries using the most CPU and tune them. This may not be the most expensive individual queries, probably isn't. The query that runs once an hour for 5...

I don't delete one row at a time, but if there's a where clause that defines which rows to delete, it's pretty easy to delete batches in a while loop,...

Other than high values of something that doesn't mean too much alone, is there a problem here?

Are the inserts getting adversely affected by the deletes? Is the delete running too...

It's unlikely to save any time, CTEs aren't inherently slow.

I took the nolock hints out, as I suspect you probably don't want incorrect results every now and again. If you...

The log backup will be the same size, or even larger, as any extents affected by the minimally logged operation are copied into the transaction log backup. The advantage is...

Sean Lange (5/4/2016)

---

Yeah they seem...

Replace 'y' with the number of characters to trim off the end

DECLARE @str VARCHAR(100) = 'adventure-works\peter0'

select substring(@str,17,LEN(@str)-(17-1) - y)

Any good bookshops in London? (for next time I visit)

Brandie Tarvin (5/4/2016)

---

GilaMonster (5/4/2016)

---

jasona.work (5/4/2016)

---

GilaMonster (5/3/2016)

---

jasona.work (5/3/2016)

---

GilaMonster (5/3/2016)

---

jasona.work (5/3/2016)

---

Heh. I'm picturing a company where their "office" is nothing more than a cage in a CoLo facility that once a...

It should initialise the log chain, copy-only is on a full backup supposed to only...

jasona.work (5/4/2016)

---

GilaMonster (5/3/2016)

---

jasona.work (5/3/2016)

---

GilaMonster (5/3/2016)

---

jasona.work (5/3/2016)

---

Heh. I'm picturing a company where their "office" is nothing more than a cage in a CoLo facility that once a month or so...