SQLServerCentral

SQLServerCentral Article

SQLServerCentral.com Celebrates our 200,000 Member Milestone

  • Article

Many thanks from Andy, Brian, and Steve to everyone for their participation and efforts in building the best SQL Server site and the best community on the Internet. In appreciation of their efforts, we've given away a few gifts to some random members.

You rated this post out of 5. Change rating

2005-01-10

2,475 reads

SQLServerCentral Article

Decorum in the Forums

  • Article

One of the most valuable features of SQLServerCentral.com is the discussion forums, where many a DBA has found an answer to their question. Most times on the same day! While we do not moderate the forums, there are still some rules for posting that we hope everyone will take a moment to read.

5 (1)

You rated this post out of 5. Change rating

2005-01-03

3,245 reads

SQLServerCentral Article

TiVo for DBAs!!!

  • Article

SQLServerCentral.com is all about learning. Our goal has been to build a community where we all teach each other how to become more proficient with SQL Server. Most of our content to date has been written articles that show you how to do something. Well we have a a better idea, maybe. Check out our new video HOWTO series.

You rated this post out of 5. Change rating

2004-12-16

3,749 reads

SQLServerCentral Article

Two Minute SQL Server Stumpers

  • Article

How prepared are you for your next interview? How prepared are you to give one? SQLServerCentral.com has compiled a number of questions from our ever popular Question of the Day into a book. Read about the project and show your support today by picking up a copy.

You rated this post out of 5. Change rating

2004-11-22

6,526 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...

We Should Demand Better

By Steve Jones - SSC Editor

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

Estimated Rows

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Estimated Rows

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