it changes, base don the version of SQL you connect to.
a connection to SQL2008R2, for example, does not have the columns [NetAddress],[ExecutionCount],RequestID], but a connection to SQL 2016 does...

parameter sniffing gone wrong can often(almost always?) be related to statistics being out of date. 
look at the tables being used in the procedure; it only takes a small percentage...

from inside the procedure, the commands run in the order you created them in, and there is no way for the third to execute before the previous commands complete.

you want to use Datetime for all values

here i am stripping out time to get the first day of the current week/Monday, and adding either one or two...

one of the know requirements when you upgrade is to update statistics for all tables, as the optimizer is different.
did you rebuild your indexes/update statistics yet, after upgrading to...

you want to store it with the line feeds in place already.

INSERT INTO YourTable ( ID, NickName,Category,Phrase)
SELECT 1,'excitedBirthday','Birthday',
'I bet you''re so excited
Excited...

its also possible with OpenXML and a script task, but the learning curve to learn to get that right is pretty steep.
once you have it though, you can decide...

stick with the SSIS wizard and avoid a linked server.
 the SELECT INTO FROM linkedServer... will be a massive logging operation, and you might run out of disk space due...

yes, i store queries like that in a table, and execute them all the time.
there are two simple ways, note i had to escape the single quotes within the...

grid view always compresses the data to a visible sinlge row, and makes CrLf appear as spaces.
what you want is to make sure a copy/paste from a grid still...

here is an example, splitting the list of all your tables in your current database, into five columns;

i think you can adapt that to only have four columns,...

the issues is object owner chaining.  cross schema or cross database queries break the object chaining inheritance, and require select permissions to teh underlying tables.
you don't want that, you...

if you have the enterprise version, Data Driven subscriptions are an option.
with data driven subscription, you might have a view that has all the info on a per row...

here's a  scripts i actually put into views ie (GoodMail and FailMail) by toggling the WHERE statement; very handy for at a glance status of emails.
so i can review...

I would assume that some other process is toggling all rows back to zero, and not that SQL is not updating after it explicitly said it updated/Completed.