SQLRNNR (7/30/2014)

---

I'm going to throw one more datatype thing out there.

The use of GUIDs as your Clustered Index will COST you plenty of space. Changing the clustered index...

I want to let this go, but I just can't.

No. Not true.

Everything, everything, within a structured storage engine comes with trade-offs...

Pretty sure the key word there is VIEW, but we could also add STATE. Same thing with VIEW DATABASE STATE.

Koen's excellent recommendations on compression are really the only way to reduce the size of data stored other than deleting the data.

Your other options are to try to tweak...

It could just be that your statistics were out of date on the old tables and the new tables, with more up to date statistics, are generating new execution plans....

While I'm sure some of the people here on SSC can help, I would strongly recommend that all licensing questions go directly to Microsoft. Regardless of what some person on...

Koen Verbeeck (7/29/2014)

---

Grant Fritchey (7/29/2014)

---

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

msandico 57892 (7/29/2014)

---

Grant Fritchey (7/29/2014)

---

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

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