Can someone who speaks Spanish please check the translations? http://www.sqlservercentral.com/Forums/Topic1804719-2799-1.aspx

Via google translate:

Hello dear, I tell them the problem I have, I have a database in which they separated in mdf, NDF and LDF files. The NDF which different filegroup...

It'll be the new cardinality estimator. Most queries improve in performance or stay the same, a small number typically experience performance regressions.

I've seen 3 clients upgrade to 2014. One did...

BLOB_EATER (7/26/2016)

---

Then I would enable TDE and do the same as above but this time showing all sort of random characters - Im guessing this is the encryption taking...

http://sqlinthewild.co.za/index.php/2011/05/17/on-transactions-errors-and-rollbacks/

Just to give you a benchmark, my new laptop has as much memory as your production server... 🙂

Lynn Pettis (7/25/2016)

---

GilaMonster (7/25/2016)

---

No, because what if there's 6 rows that need inserting and 4 updating?...

No, because what if there's 6 rows that need inserting and 4 updating? To use rowcount,...

http://source.entelect.co.za/why-is-this-upsert-code-broken

I've heard that before. Often followed later by finding out that something had changed somewhere upstream and there now were duplicates

If you're...

Assuming you're referring to Always On Availability Groups, that can't cause primary key violations. It's a high availability feature that provides secondary servers to take over if the primary fails....

And missing any form of error handling.

Doesn't mean the transaction has to be committed, you can get the IDs within the transaction. You can get them from the insert using the OUTPUT clause, then use that...

Why?

What you can also do, to narrow down the cause, is schedule a job to write the following into a table, during the backup process.

SELECT name, log_reuse_wait_desc FROM sys.databases

WHERE name...