Viewing 15 posts - 1 through 15 (of 59 total)
I agree with Johan's approach. Use Data Migration Assistant to check for deprecated code.
Go with a new server with all the latest. You build it with a different name like...
June 8, 2022 at 7:58 pm
Thanks for everyone's input. I presented my findings to the SR DEV, he also feels the Bank subquery is redundant. He also doesn't believe we need DISTINCT and NOLOCK. He...
November 8, 2021 at 4:46 pm
No missing index suggestion. It didn't use the your recommended one.
November 8, 2021 at 2:24 pm
But when Jonathon added both columns the WHERE clause, it might have taken care of it.
c.CustomerNumber = t.CustomerNumber
AND c.Customer = t.Customer
Jonathon, your second query brought the spool back. But I...
November 5, 2021 at 4:11 pm
I don't understand what you are trying to do or your data. But I think the part:
Bank = (Select Bank From Customer Where Customer=t.Customer)is redundant.
I'm...
November 5, 2021 at 4:00 pm
What is the difference in using 'EXISTS' instead of 'IN'?
November 5, 2021 at 2:47 pm
Agreed, the NOLOCK was already on my radar.
November 5, 2021 at 2:39 pm
Thanks guys. I also thought the Bank filter may be unnecessary. I tried removing it and got one more record than with it, I'll look into that. It ran extremely...
November 5, 2021 at 1:10 pm
Edit: Wrong Answer
November 4, 2021 at 10:02 pm
August 15, 2018 at 7:00 am
Are your Statistics up to date?
I see it estimated 1.5 m rows but the actual was 4.2 m rows.
Then the sort spilled to TempDB.
November 30, 2017 at 12:43 pm
I experienced this after my first migration.
I moved a database to new fast hardware but the speed seemed the same or worse.
I ran DBCC UPDATEUSAGE and SP_UPDATESTATS against the database.
It...
April 6, 2016 at 2:33 pm
I had this issue in the past.
The culprit was a third party tool where log files that were not purged.
Redgate's SQL Backup didn't set a purge by default on the...
November 18, 2015 at 9:02 am
If you are changing the name of the server you need to dropserver/addserver.
--These Steps are needed after you rename the new server to the existing server name
sp_dropserver 'ServerName_New';
GO
sp_addserver 'ServerName_Existing', local;
GO
--restart...
November 18, 2015 at 8:49 am
Viewing 15 posts - 1 through 15 (of 59 total)