I think I did that a few times writing...

Do some testing. I have no idea what your table is, but I did this:

CREATE TABLE News

(NewID INT IDENTITY(1,1)

, NewsTitle VARCHAR(250)

, NewsAbstract VARCHAR(6000)

, NewsDate DATETIME2

)

GO

I loaded 50,000 random rows in...

I tend to agree with Jeff on performance. If something is a one-off, maybe you sacrifice performance for getting things done, but if it repeats, don't treat the process lightly.

I've...

Perhaps you can share some DDL and data to understand what you mean.

First things, I wouldn't change the IP here. I'd actually change to an FQDN, and use that in the future. There have been reports of issues here, so if you...

I'm confused. Service accounts are Windows accounts only. If you're speaking of logins in SQL Server, then follow the advice above with regards to password policy

Will? Isn't it?

It has before. After the 70s, quite a drought.

But they will come...

This is a Windows level setting, and usually there is a limit. I think it's 3, but it might depend on your particular OS version and AD settings.

I might set...

+1

It is a regular battle. One reason that RG moved to outsource the sending. I used to do this, and it was a day a week to work through spam...

Absolutely true as a hypothesis.

Not very true in reality. Most...

Yankees for me, and Rockies since I live in Denver.

Too busy with kid stuff this year. Middle kid graduates HS and the younger one is busier with volleyball. Add in...

All of those are valid statements in my SQL 2012 and SQL 2014 instances. Didn't try 2016, but I'm sure it's the same.

You have different control of tempdb. I believe...

Have to say I'm less excited this year. Between not playing (time, shoulder), and the Rockies not looking good, I'm a little down.

🙁

I hope to be