Press Release


Technical Article

SQL Saturday #333 - St. Louis, MO

SQL Saturday is coming to the St. Louis University Campus on Oct 11, 2014. SQL Saturday offers a full day of free SQL Server training and networking, some of the speakers at this event include Kathi Kellenberger, Stuart Ainsworth, and Abhishek Srivastava. If you're thinking of attending this event, please register while space is available.

2014-09-25 (first published: )

13,541 reads

Technical Article

Silicon Valley Code Camp

Code Camp is a community event where developers learn from fellow developers. This year's event will take place on October 11-12 in the Los Altos Hills in California. Speakers include Steve Jones, Nik Molnar, Anthony van der Hoorn, Mike Wood, and more. Register while space is available.

You rated this post out of 5. Change rating

2014-09-08

6,152 reads

Blogs

SQL Server Alerts

By

Don’t Let Trouble Sneak Up on You   Most SQL Servers run quietly. Until...

Prompt AI helping with Auditing

By

I had a conversation with a customer asking this question: how can I tell...

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

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

Collation errors...what is best way to deal with it?

By water490

Hi I have a SP that occasionally get this error: Cannot resolve the collation...

Was the index created or not?

By water490

Hi everyone I am getting an error when I create the index but I...

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 in SQL Server 2022?

See possible answers