TheSQLGuru (12/4/2015)

---

The simplest solution by far would seem to be fix the data. 🙂 Update all NULL start-date values to the minimum for the data type (1/1/1753 for full datetime...

Code below should filter it for a single month, as specified in @month:

LEFT JOIN (SELECT COUNT(CA.app_id) AS Approved_Count, SO.source_id

...

I'd urge you to use triggers rather than application code for this type of thing. This makes sure the code is consistently applied and prevents having to re-write code...

I'd create such a proc in the master db and mark it as a system object so that it could be used in all dbs.

I'd also at least:

1) optionally allow...

In more detail, index "FDX_spG_NU_QA_V12" does not contain at least one of the columns:

MC.col1 / MC.col2 / MC.col3

If you believe such an index could be helpful enough to this query,...

It was my understanding that SQL only acquired RAM when it needed it. That is, it doesn't automatically grab the max ram as soon as it starts. Of...

Using the spreadsheet I just posted, let's look at the xactControlPoint table. Notice my script adds an "ident" column before each missing index stat. That is to reference...

--Edit: removed, exact dup of next post, I got an error during posting and didn't realize it had actually posted anyway.--

I've adjusted the spreadsheet you originally posted to have both missing index and index usage stats. That is the minimum info needed to analyze indexes. I've pulled the...

This may be more efficient (most people use LEFT rather than RIGHT join, so I switched it to that):

SELECT l.value, p.productname

FROM dbo.ProductTable p

LEFT OUTER JOIN (

SELECT...

Re1 (11/27/2015)

tbl_documents table is having 700 rows and tbl_documentdetails table is having 1.6 millions+ rows.

I have created index on tbl_documentdetails table on invoiceid,orderid,billid column as per sequence used in join...

This isn't really all that complex, and we can use code that doesn't require any specific date setting(s). I used a CROSS APPLY just to get the date calc...

Welsh Corgi (11/26/2015)

---

Thank you very much for your help.

I'm looking to partition by year.

My current archive code looks up the year in a lookup table.

I want to mimic that logic...

Hmm, in the spreadsheet...

Sergiy (11/25/2015)

---

The stats look...