$100/yr seems pricey to me, but I get that they're trying to provide the service. What I'd really like is a $2 game. I listen sporadically, and usually want to...

There's a lot of truth here.

SQLRNNR (3/4/2016)

---

Andy Warren (3/4/2016)

---

Too many zeros!

The referenced post about running out of bigints is interesting - a comment to that post suggests it's possible in some environments - I want...

n.heyen (3/4/2016)

---

To all who gave suggestions and arguments for and against, many thanks. I apologize for not responding quicker, I do really appreciate the time everyone gave me to provide...

I agree. He was better last year. However I still think of the collapse against the Red Sox. I was sure he'd never get a ring, since he just doesn't...

Jeff showed some examples:

http://www.sqlservercentral.com/articles/Data+Generation/87901/

http://www.sqlservercentral.com/articles/88964/

I dislike A-Rod, as I've disliked Clemens and Boggs in years...

Gary Varga (3/4/2016)

---

I have still yet to come across a requirement that would benefit from the use of a tally table. I read up so much about it but that...

You could do that, and some do. I...

Good. That was the intention

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...