Viewing 15 posts - 9,931 through 9,945 (of 59,065 total)
I have inherited a 1600+ line stored procedure at my work that imports sales orders...
January 24, 2019 at 7:19 pm
A couple of things come to mind as "possibilities".
1. You've verified that the database that you're looking at is the database the code is executing in, correct?
2. ...
January 24, 2019 at 7:16 pm
January 24, 2019 at 7:01 pm
January 24, 2019 at 6:47 pm
I'm pretty sure that no matter what happens, there's going to be a table or index scan involved and that there will also be a SORT involved. Borrowing heavily on...
January 24, 2019 at 6:30 pm
January 24, 2019 at 4:39 pm
January 24, 2019 at 4:26 pm
January 24, 2019 at 4:16 pm
I had an old boss that got angry with me even though we were great friends especially professionally. He had a Developer write code to download and import the data...
January 24, 2019 at 9:34 am
I think the following link may have the answers to all of this...
https://docs.microsoft.com/en-us/sql/relational-databases/database-mail/database-mail-log-and-audits?view=sql-server-2017
January 23, 2019 at 11:15 pm
and...
January 23, 2019 at 10:39 am
this is because the keys of the Clustered Index become a part of the...
January 23, 2019 at 9:46 am
January 23, 2019 at 8:00 am
Viewing 15 posts - 9,931 through 9,945 (of 59,065 total)