msandico 57892 (7/29/2014)

---

Grant Fritchey (7/29/2014)

---

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...

As long as we're talking about straight T-SQL commands, you should be fine. If you start trying to access objects directly through SSIS, you may hit issues. Forward compatibility is...

mqbk (7/29/2014)

---

Grant Fritchey (7/29/2014)

---

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...

Nothing but opinion follows. Take due notice and govern yourselves accordingly.

If we're talking a database administration job working anywhere outside academia (or evidently, the government), the degree itself is unlikely...

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...