ScottPletcher (8/17/2016)

---

No. If you disable a nonclustered index, SQL can no longer trust the index and thus can't use it to satisfy queries. If you don't need the...

Probably failing too early in the connection process, before it got to a point...

That error sounds like the instance of SQL you're trying to connect to isn't running (via named pipes). Double-check the server names/instance names and make sure you're trying to connect...

No. It probably will be...

You can, though whether that's...

ScottPletcher (8/16/2016)

---

I though the number of row mods needed was based on the number of rows in the table, and was either a fixed number or a percentage of...

You don't. Not exactly

Partition boundaries have to be fixed values, so you can have a partition...

There's a reason I teach my devs to script out the restores before running them and check what the script does. 🙂

I've done it before as well, using triggers. It's a pain in the neck to get right and keep in sync, and the queries to get the correct point in...

It must be getting created by some application installed (or possibly even some malware that's installed, the file names don't sound legit)

Try running a server-side trace for a while and...

vsamantha35 (8/11/2016)

---

You mean create indexes and do some query tuning to speed up queries?

FYI we are pulling large datasets from different source systems and load data into a datawarehouse...

No, because timeouts are not a database setting.

A timeout is the application deciding it's waited too long and notifying SQL to stop the query. It is not SQL deciding...

No.

The witness is there solely to check whether it can see the principle or mirror to decide whether to failover the mirroring...

What two time periods? There's only one datetime per row.

Yes, but column statistics only, not index statistics (they got updated with the index rebuild)