jellybean (3/31/2015)

---

Ok guys let me summarise before I close off this very excellent thread:-

Process to up-greade to SQL Server 2014 from 2005

0. On the *separate* target box install Sql Server...

Jeff Moden (3/30/2015)

---

krypto69 (3/30/2015)

---

Thanks Grant.

Long story, but it's financial data and I'm new there so can't complain..yet.

Kinda figured those were my only options. Shame I can't use my high avail...without...

You'll have to combine that view with other functions and views to get a complete picture. You can use sys.dm_exec_sql_text to get the query and sys.dm_exec_query_plan to get the plan.

I'd...

Why would developers need live data to develop against?

But, if you have to, the technologies you have available are somewhat limited because they will prevent changes to the database. For...

The best way is to capture queries using extended events. You can see how much memory the query consumes. You can also look at sys.dm_exec_query_stats to see some aggregation information...

No, the data gets updated AND the log gets written. As was stated above, this is to help maintain ACID properties and it makes it possible to do point in...

But if you're not using differentials, you can use the secondaries for backups. Also, the log backups can, roughly, be taken anywhere and then combined later. I wrote a chapter...

I have not done the 2005 SP4 upgrade to 2014, but, if the documentation says it supports it, it probably does.

I'd go with the first setup you have suggested there....

I am just not sure. I'm not seeing indications for why it's going wrong. Double check that the constraint has the WITH CHECK option in 2014. Other than that... I...

That doesn't mean it will lock the entire table (unless you're deleting a pretty substantial portion of it, but that's part of why you break it into smaller batches). It...

Breaking it into pieces and making sure that the delete statements are using indexes instead of scanning, those are really your choices if you can't partition the data.

If you don't have any sort of auditing set up on your server, you won't be able to see who deleted data. You can set up Audit within SQL Server....

Wish I could come over and play with this. The check constraint should allow the optimizer to eliminate servers from the choice. The fact that security might have changed the...

Alan.B (3/26/2015)

---

I suspect he meant...

Piling on.

Triggers are not bad. They just have a hidden behavior that, when they're written poorly, can lead to lots of issues and long troubleshooting sessions. Use appropriately, they're fine.

Now,...