If you're getting problematic plans, it's probably because of out of date statistics, so getting more up to date statistics is usually the solution. USE PLAN might not work that...

Doctor Who 2 (7/19/2016)

---

Hi Steve,

Tonight I have a chance to go through the MSDN article you've posted in response to my question. It looks as though I need to first...

Absolutely!

Also, plans can look the same but still be very different on the inside, estimated versus...

And then check for compression on the one with fewer reads.

Upwards compatibility is never guaranteed. This is because new functionality is introduced that older software can't cope with.

You just have to set up your network so that the server is visible within it, then you're off to the races.

Rod at work (7/18/2016)

---

Grant Fritchey (7/18/2016)

---

You can't restore to an Azure database. You can create a BACPAC and deploy that to Azure to create a new database, but a backup/restore...

You can't restore to an Azure database. You can create a BACPAC and deploy that to Azure to create a new database, but a backup/restore won't work.

I just recently published a blog post [/url]on this very topic. I'd suggest doing the checks that I did.

I'm pretty sure you asked this question once already. Everyone suggested you use VARCHAR(MAX) but not TEXT, because TEXT is deprecated. Here's the documentation on VARCHAR. It stores up to...

GilaMonster (7/14/2016)

---

I'm not so sure. The average wait time is around 5ms for the SH, 1.5ms...

muth_51 (7/13/2016)

---

If we have a fill factor of 100 and a table is hit with heavy inserts and deletes. How the new data gets inserted? Does the data removed from...

More information is needed. I'd double check the server configuration, memory settings, etc. Are there other processes running on that machine? What are the wait statistics? This is about investigation...

Assuming those are the top 3 waits, yeah, you have page latch issues. Here is a white paper on the issue from Microsoft. Here is discussion around the issue [/url]from...

I'm curious now, what are you trying to store? And which data...