ozkary

Oscar Garcia is a Principal Software Architect who resides in South Florida. He is a Microsoft MVP and certified solutions developer with many years of experience building enterprise software solutions. He specializes in building cloud solutions using technologies like AWS, Azure as well as data platform and BI projects for data visualization using SQL Server, Firebase, Redshift, JMP, Tableau and PowerBI. You can follow Oscar on Twitter @ozkary or his blog at www.ozkary.com
  • Interests: big data, data science, cloud data platform
  • Blog: ozkary.com
  • Skills: Data Platform

All authors

All authors

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

Cruelty-Free Cosmetics Market Subject Mastery for Competitive Edge

By sunita

The global Cruelty-Free Cosmetics market is a dynamic and promising industry that has shown...

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