Joy Smith San (5/11/2015)

---

Thanks Grant & Perry

If you're in the extremely large database sphere, you may find that backups running for 26 hours just doesn't work. Especially when restores can...

Since the only error you have found is "Terminated Abnormally" it's really hard to say. As I said, the most common error there is permissions, but I believe you. Second...

First, when examining whether or not a missing index suggestion is good, please, change the name from [<Name of Missing Index, sysname, >] to anything else.

Next, while that may have...

Both approaches sound like excessive locking to me. Why are they putting such stringent locks on the system to begin with? Most people are trying to avoid locks and the...

Durations suggest that the other backup is failing same as the native backup. It sure looks like a permissions issue. Running it as yourself is going to be different than...

Charles Kincaid (5/9/2015)

---

Stored procedures cache the execution plan at the time the procedure is compiled. On the other hand a query may get a new execution plan every time...

I have not seen this, but would be very interested if such a thing existed.

One small measure that you can use is the estimated cost within the execution plan. It...

You'll also see the predicates used against the indexes come from the ON clause or the HAVING clause in queries. Don't be surprised if it's not just your WHERE clause....

xsevensinzx (5/8/2015)

---

This is the uphill battle I face though. I have no verification if 1 million or 5 million identical rows are correct or incorrect. Thus, all are assumed correct...

All good choices. Another way would be to capture extended events (or trace) for all insert/update/delete commands against the table. It won't show rows affected, but you can tell what...

That's not really ad hoc or dynamic SQL. The query is going to be the same every time you run it. You're not building it on the fly. You just...

xsevensinzx (5/8/2015)

---

GilaMonster (5/8/2015)

---

xsevensinzx (5/8/2015)

---

What if you are allowed to have duplicates with transactional records that have customer ID's which forms the relationship? What purpose is the PK giving you outside...

The execution plan doesn't seem to have made it. Plus, posting a picture of an execution plan is not posting an execution plan. The important parts of an execution plan...

xsevensinzx (5/8/2015)

---

spaghettidba (5/7/2015)

---

A relation must have a primary key. If your table does not have a primary key, then it's the physical implementation of something that doesn't exist in the...

Based on just general outline, it's hard to make substantial suggestions.

At it's core, a deadlock is about performance. If a transaction completes extremely fast, the chances of it causing or...