OK, I'm still experimenting and trying things and I finally got it to use my new Index...but does an index scan versus a seek...Not sure how to approach that.  In...

Below is the predicate...Ive created an index base on this column, then included all fields within the Output List (20 total) and no good.  Tried making an index with the...

Thanks for the confirmation. I'm going to dig a bit more and see if there is any refinement available on the AD side to link application to security group. I...

Thank You...I am going to make a...

Finally found the issue as a result of testing and monitoring as suggested by y'all. The Cartesian Join comment got me thinking...what could cause a TempDB to grow full...

Lynn Pettis (7/12/2016)

---

chris_barnhart (7/12/2016)

---

Thanks for the advice...we have a contractor on the way, but not until Monday.

I've been monitoring the consumption using the first set of SQL, the second one...

I believe its the latter reason...he had backup jobs set up on the server, but not for this DB. It did in fact grow too large since I truncated...

Thanks for the advice...we have a contractor on the way, but not until Monday.

I've been monitoring the consumption using the first set of SQL, the second one shows me queued...

I apologize...i knew I would leave something important out. Error is below:

(Message 2528) DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000] (Message...

I'm using the following 2 queries in conjunction with each other to actively monitor the problematic jobs:

SELECT

SUM (user_object_reserved_page_count)*8 as user_obj_kb,

SUM (internal_object_reserved_page_count)*8 as internal_obj_kb,

SUM (version_store_reserved_page_count)*8 as version_store_kb,

SUM (unallocated_extent_page_count)*8 as freespace_kb,

SUM...