1tb isn't quite into the VLDB range, but, once you get past around 3-5tb, you need to start looking at things like SAN snapshots. But, even that could be problematic...

While you can connect to it, you won't be able to access 2014 objects and may run into issues with objects that contain 2014 only constructs (clustered columnstore).

The issue, whatever is causing the slowdown, could very well be within SQL Server. Absolutely. But the timeout itself is controlled at the application connection setting.

So, to troubleshoot this, I...

Anything that the server does in a completely automated fashion needs to, under most circumstances, and in most cases, not cause harm. Rebuilding indexes could be problematic. For example, an...

patrickmcginnis59 10839 (7/28/2014)

---

Koen Verbeeck (7/28/2014)

---

patrickmcginnis59 10839 (7/28/2014)

---

Ed Wagner (7/28/2014)

---

SQLRNNR (7/27/2014)

---

So they named...

pmscorca (7/23/2014)

---

I don't use the Retail channel to buy SQL Server.

I repeat that I know that SQL Server 2014 has rights to downgrade.

Simply, I want to know how technically I...

Schema changes will get modified across in the same way as anything else. If you have to have users off one system to make the changes, you need them off...

Best answer I can give you is to test it. In all likelihood, I'd say, yes, you'll see a performance benefit since the vast majority of systems have more reads...

Uninstall and reinstall. There is not a "downgrade" path for installations. If you don't have databases to worry about, it should be very quick.

I see what everyone is saying and I don't disagree with them, but I know where Brandie is coming from. You make compromises in order to make things work well....

They...

I'm really not going to do the work for you.

I'll give you a hint to get you started though. There are three items listed above that are people. Figure out...

Brandie Tarvin (7/23/2014)

---

There are people who will disagree with me on this, but I have found adding an IDENTITY (1,1) column to the table and adding that to the natural...

For the same server, with the same data, on the same database, with identical statistics, for a single execution, with absolutely zero contention, you should be seeing roughly the same...

Thanks for posting your solution. Now when anyone searches for this same problem and finds it, they'll know what you did to solve it. That really helps.