Viewing 15 posts - 1 through 15 (of 142 total)
April 6, 2018 at 6:33 am
Jeff, this is the method I was looking for and the results in are in line with what I wanted. Thank you so much for your help.
April 6, 2018 at 6:04 am
Thanks Steve. I will study this. I really appreciate you taking the time to put this together.
April 5, 2018 at 3:56 pm
Thank you for this great list! One keyboard shortcut I would like to add is CTRL+SHIFT+R. This will refresh the intellisense cache to allow that new object you just created...
August 14, 2017 at 6:59 am
SELECT T.InvoiceNumber, T.EntryCode AS InvoiceEntryCode, T.StoreNumber AS InvoiceStoreNumber, T.RptLevel AS InvoiceRptType,OA1.* FROM...
May 11, 2017 at 3:32 pm
Thank you Sergiy for the suggestion.
January 13, 2017 at 6:54 am
Thank you for the input Frederico!
January 6, 2017 at 11:40 am
An update. The first thing I did was to change the @CODA and @WarrPolCusts to temp tables instead of table vars. This took the query right at 10...
January 6, 2017 at 9:44 am
Here is the t-sql in the store procedure that is running the query that is taking the time. The execution plan that is bad is what is produced base...
January 6, 2017 at 9:08 am
One other thing I noticed. I went back to see when the stats were last built on the TAB.tblWorkOrderSegInvoices table and it was today. I guess when I...
January 6, 2017 at 8:48 am
Thanks Jeff and Chris. I cannot thank you enough for taking your time to help me.
Chris, I did see that the table vars are causing the estimated rows to...
January 6, 2017 at 8:35 am
It looks like it may have been a while.
Attached is the query plan. The main query that is the trouble is Query 3. As you can...
January 5, 2017 at 11:52 am
Thank you Chris for offering to look at this. I'm running it now. I'm warning you now that its not pretty. I'll upload as soon as it...
January 5, 2017 at 10:03 am
Thanks for the reply. Looks like our PCs are controlled by GPOs on Windows updates. So I'm going to have to look into this more and give it...
July 8, 2016 at 9:20 am
ChrisM, you pulled that trick out of the bag just in time. I needed this for something I worked on today. Thank you taking the time to put...
February 5, 2016 at 3:12 pm