It would probably be best to first approach this issue by confirming that statistics on tables and indexes are up to date and also by simplifying the JOIN and WHERE...

Just like a non-clustered covering index can eliminate reads from the base table, an indexed view can be thought us as a covering index for eliminating multiple joined tables.

Jeff Moden (10/25/2016)

---

Eric M Russell (10/25/2016)

---

Marcia J (10/25/2016)

---

I remember in the late 80's saying that the 2-digit year would be a problem and getting the message from other programmers, "So...

So who or what can change your server configuration settings?

You probably don't want your development environment to have features that are not expected to be deployed in production, unless the feature is being used to facilitate the development process....

If you have a monitoring tool like Redgate or SQLSentry, then go back and check for any extended periods of blocking on the backup process that may have occurred during...

What is the difference between a CHECK CONSTRAINT and error handling?

A CHECK CONSTRAINT will automatically throw an error in response to the insertion of invalid data.

TRY + CATCH...

A .dtsx file contains the source code for the SSIS package (in XML format), while .ispac is a ZIP formatted file containing .dtsx files, .params file, .manifest file, and other...

Marcia J (10/25/2016)

---

I remember in the late 80's saying that the 2-digit year would be a problem and getting the message from other programmers, "So what? I'll be at...

Kazmerelda (10/25/2016)

---

Now they want to offer me RAID5 instead of RAID10 *weep*.

Eric, I think you could be right here I am a belt and braces person and I don't overspec...

A disgruntled DBA is the equivalent of a zombie clown with...

Gary Varga (10/25/2016)

---

Geoff.Sturdy (10/25/2016)

---

Gary - the two digit year was born out if the need to conserve memory in early systems - back in the late 70s /early 80s...

Super_Grover (10/23/2016)

---

Hi all,

I must transfer a big table (231k rows not that big, but 735GB big because of blob) to another location by INSERT INTO SELECT FROM...

It appears that first...

This is why corporations hire their own staff lawyers and scientists; they don't want to know how best to do things; they just want to know how close to the...

When we speak of no-schema databases and analytical tools, I assume we're referring to a data store essentially intended for staging and exploration. It truly is a bucket of 1s...