Lord Lucan (9/2/2015)

---

I'm based not far from Cambridge and my current role is in Cambridge but I'm away that weekend. Doh!

Grant- no worries, I have much to learn about...

Based on the general suggestions you're making, no. What you're suggesting is referred to as Nested Views. It's a common code smell that leads to quite a few problems. The...

arr.nagaraj (9/2/2015)

---

@steve-2,

The idea struck me when I wanted to read the blogs /articles , stairway series via mobile while I was travelling. Doesn't that sound appealing?;-)

Forums are best suited for...

Yes. Differentials are tied to...

Lord Lucan. The Charge of the Light Brigade. The battle of Balaclava. The Crimean War....

ZZartin (9/2/2015)

---

David.Poole (9/2/2015)

---

If you are the person who will bear the consequences then if you are willing to do so then you can do without foreign keys. Chances are...

I have no control over this, but I'd beg Steve to not suggest it. Keep the Redgate programmers working on what they're working on.

Oh, and please, attack the Heights, not the guns.

Welcome to the party.

Sounds like you're doing well and learning as you go. Reading the articles here will help. A strong suggestion, read the questions and try to answer some....

I would focus on using PowerShell. You can make the call to the procedure, capture the output to file. It's the most direct mechanism available. You'll have maximum control and...

If you add the next log backup, you should be able to get to 3:10.

Assuming you changed the compatibility setting on your database so that it's now at 120, you're using the new cardinality estimator that comes with SQL Server 2014.

Queries that were marginal...

sunnyepgc (9/2/2015)

---

I do not have sufficient permission to add deadlock trace.Actually I am inserting new records into Target table (say Table B) using Merge statement (WHEN NOT MATCHED), I have...

The biggest difference between 2008 & 2014 was the new cardinality estimator. First off, make sure the database compatibility mode is set to 120. If it is, you're using the...

Better to use Extended Events, but yeah, both have a recompile event that you can observe.