Katerine459 (2/27/2015)
(Edit to add: How do you post an execution plan from SSMS?)
See
Grant Fritchey
The Scary DBA
Author of:
SQL Server Query Performance Tuning
and
SQL Server Execution Plans
These are available here:
http://www.red-gate.com/community/books/
Otherwise, Click the "include actual Execution plan" button on the toolbar in SSMS.
Run the query
You will now see three tabs, Results, Messages, and Execution Plan.
Pick the Execution Plan tab, right click, pick 'Save execution Plan as" and attach it to a post.
Michael L John: Regarding Indexes: I do have some in the database, but those two tables just have PK indexes (ClientID in the Clients table, and ClientSheetID in the ClientSheets table). I've been thinking about adding a combined index for ClientID, MonthNum, and YearNum, but haven't been able to wrap my head around the advantages/disadvantages for doing so.
Are these indexes clustered?
And why do you think adding an index on ClientID, MonthNum, and YearNum will be a good thing?
See, we are challenging (and probably torturing) you!
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/