Editorials

SQLServerCentral Editorial

What is Possible?

There’s the old saying “Whether you think you can or you think you can’t -- you’re right” from Henry Ford. I’ve thought about this more recently while reading the book The Rise of Superman Decoding the Science of Ultimate Human Performance which talks about how athletes have performed so called impossible feats over the past few […]

You rated this post out of 5. Change rating

2020-10-31

94 reads

SQLServerCentral Editorial

Building Quality In

I heard someone at the 2020 DevOps Enterprise Summit conference say that quality needs to be built in. That's something that many, or hopefully most, of us believe. Everyone ought to do quality work and build it into their daily tasks. However, the person speaking went further and defined this in a way I like: […]

5 (2)

You rated this post out of 5. Change rating

2020-10-29

185 reads

SQLServerCentral Editorial

What's Causing the Pushback with DevOps?

The term DevOps gets horribly abused. Don’t get me started on all the weird additions to it like DevSecOps. No, I just mean the term itself gets beaten up quite a lot. It’s to the point where people are starting to shy away from talking about it. I’ve even changed my approach when discussing DevOps […]

You rated this post out of 5. Change rating

2020-10-24

162 reads

Blogs

From Data Custodian to Innovation Catalyst: The Evolving Role of the CDO

By

There was a time when the Chief Data Officer lived in the shadows of...

Down the Rabbit Hole: Dealing with Ad-Hoc Data Requests

By

"But I don’t want to go among mad people," Alice remarked."Oh, you can’t help...

Adding a Local Model to Ollama through the GUI

By

I saw some good reviews of the small gemma3 model in a few places...

Read the latest Blogs

Forums

Create an HTML Report on the Status of SQL Server Agent Jobs

By Nisarg Upadhyay

Comments posted to this topic are about the item Create an HTML Report on...

SSIS Package is reporting successful however is short 80-100k records

By cpiacente

Good morning all, I have been running into a very random weird issue that...

We Should Demand Better

By Steve Jones - SSC Editor

Comments posted to this topic are about the item We Should Demand Better

Visit the forum

Question of the Day

Estimated Rows

I have two calls to the GENERATE_SERIES TVF in this code:

SELECT   TOP 10 gs.value
FROM     GENERATE_SERIES(1, 10) AS gs
ORDER BY NEWID ()
OPTION (RECOMPILE);
go
DECLARE @a int = 10;
SELECT   TOP (@a) gs.value
FROM     GENERATE_SERIES(1, @a) AS gs
ORDER BY NEWID ()
OPTION (RECOMPILE);
In the actual query plans, what is the estimated number of rows for each batch?

See possible answers