To be sargable, the query would need to filter on the leading column in the index.

For example, assume we have CLUSTERED INDEX ( StoreID, TransactionID, ProductID ). A query WHERE...

Unless the log growth was the result of a one-off process and the disk space is shared by other databases, I don't see the point in shrinking. Maybe focus on...

Ed Wagner (8/16/2016)

---

Eric M Russell (8/16/2016)

---

Ed Wagner (8/16/2016)

---

Eric M Russell (8/16/2016)

---

It would be useful to have an experienced gray haired DBA who could offer technical assistance and architectural advice across...

Ed Wagner (8/16/2016)

---

Eric M Russell (8/16/2016)

---

It would be useful to have an experienced gray haired DBA who could offer technical assistance and architectural advice across any number of projects, more...

It would be useful to have an experienced gray haired DBA who could offer technical assistance and architectural advice across any number of projects, more like an analyst role, wihout...

The engineering DNA of the SQL Server database engine is optimized for online transaction processing, not bulk loading or aggregation.

You may also want to consider BCP-ing the 600 GB...

When SQL Server constructs an execution plan, it takes a lot of things into consideration and it attempts to come up with a good balance. If it is known that...

Ed Wagner (8/15/2016)

---

Eric M Russell (8/15/2016)

---

When it comes to revceiving data feeds from external clients or 3rd party providers, it's best when an auto-certification process breaks the file transfer when...

Northwind is obsolete. It was replaced by AdventureWorks, which was replaced by Contoso.

Here is the CodePlex site where Northwind is maintained. It hasn't been updated since release 2008, but you...

Don't say "explosion" in the context of manned rockets. Instead say...

When it comes to revceiving data feeds from external clients or 3rd party providers, it's best when an auto-certification process breaks the file transfer when the file isn't formatted properly....

There is no secret sauce in SSIS that allows you to insert a table without transaction logging.

The following article provides a good explanation of minimal logging and summary of the...

HappyGeek (8/11/2016)

---

So how exactly do you...

Table Partitioning, TDE, and page compression can all work in conjunction.

Chief Executive Officer, Chief Information Officer, Chief Happyness Officer, etc.

We're all...