Ok, let's see what this shows:

IF OBJECT_ID('tempdb.dbo.#showfilestats') IS NOT NULL

DROP TABLE #showfilestats

CREATE TABLE #showfilestats (

Fileid smallint NOT NULL,

FileGroup...

417 pages is a trivial size, you can ignore it if that's the total.

Does "DB size shows 215 GB" include log file? If so, what size is the log...

I suggest RECOMPILE as well. That may take some time, but it will be trivial compared to a terrible plan.

Also, if you leave auto stats update on, explicitly set...

SQL also creates internal tables for certain types of data, including: primary XML indexes,

service broker, change tracking and a few other things. You'll need to include the size...

Robert Frasca (12/2/2014)

---

Grant Fritchey (12/2/2014)

---

ScottPletcher (12/2/2014)

---

Robert Frasca (12/2/2014)

---

ScottPletcher (12/2/2014)

---

Robert Frasca (12/2/2014)

---

ScottPletcher (12/1/2014)

---

I guess the SourceFactTimeCard table is fairly wide?

I suggest creating a covering index on:

SourceFactTimeCard (...

Robert Frasca (12/2/2014)

---

ScottPletcher (12/2/2014)

---

Robert Frasca (12/2/2014)

---

ScottPletcher (12/1/2014)

---

I guess the SourceFactTimeCard table is fairly wide?

I suggest creating a covering index on:

SourceFactTimeCard ( TimecardIndex, EmployeeID )

If SQL then...

eric.notheisen (12/2/2014)

---

In our company sharing user passwords is a firing offense. As developers needing to troubleshoot user defined defects, we restore the production database to our development VM's and...

Robert Frasca (12/2/2014)

---

ScottPletcher (12/1/2014)

---

I guess the SourceFactTimeCard table is fairly wide?

I suggest creating a covering index on:

SourceFactTimeCard ( TimecardIndex, EmployeeID )

If SQL then uses that covering...

SQL allows you to designate a proc(s) as "start up" procs that automatically runs when an instance starts. I was suggesting you create such a proc, or add code...

I guess the SourceFactTimeCard table is fairly wide?

I suggest creating a covering index on:

SourceFactTimeCard ( TimecardIndex, EmployeeID )

If SQL then uses that covering index -- it...

SELECT CONVERT(varchar(10), DATEADD(DAY, DATEDIFF(DAY, 0, dt), 0), 120) AS dt, SUM(amt) AS Amt

FROM @t

GROUP BY DATEADD(DAY, DATEDIFF(DAY, 0, dt), 0)

You can pass @StartingDate as a param to the ITV function.

Also, you can simplify the calc for PastPeriods:

MONTH(@StartingDate) % 3 + 14

You'll need to create a start up proc for each instance that checks for the different conditions.

Since you have to change both instance's memory settings, I'd create a proc in...

ZZartin (12/1/2014)

---

ScottPletcher (12/1/2014)

---

GilaMonster (11/30/2014)

---

I didn't say stop using select. I said stop using SELECT *. Explicitly define what columns you need and...

GilaMonster (11/30/2014)

---

I didn't say stop using select. I said stop using SELECT *. Explicitly define what columns you need and you won't...