The IS in SSIS stands for Integration Services, not integrated services.

And installing that is a separate service, so it won't mess with the database engine other than to create a...

And what exactly do you mean by 'Integrated Services'?

Service pack, only if it fails or breaks part way through.

Literally that. A round trip across the network, client to server and back.

After creating an SP. 0.

What do you mean by 'component'?

jeff.mason (5/2/2016)

---

Oh, you don't want to do that, especially in a system with MARS involved. That would cause multiple recordsets potentially. You probably want to make a log table...

It's returned to the caller, but since the Edit window doesn't have any way to show resultsets coming back, it would have been discarded by SSMS.

Write an update statement, and...

Parallelism isn't a problem.

Firstly you should be using nvarchar(max) since ntext has been deprecated for ~11 years, but the problem does sound like the width. ntext isn't defined with a width, it's just...

The first requires one network round trip, the second multiple. That's all.

Second question, is...

I suggest you get familiar with the SQL documentation (Books Online)

https://msdn.microsoft.com/en-us/library/ms189631.aspx answers both that and earlier questions.

FYI

https://blogs.technet.microsoft.com/dataplatforminsider/2016/05/02/get-ready-sql-server-2016-coming-on-june-1st/

Fix that first. 5 is insanely low. Set it higher.

As for the rest, the numa config is written into the error log on startup. The guidelines are either number of...

Absolutely no...

I hope not to 24.

I have one doubt do we need to disable autogrowth for tempdb and set...

N_Muller (4/29/2016)

---

Grant Fritchey (4/29/2016)

---

I'll just pile on and agree.

The main issues I've seen are with multi-statement,...