Bert Wagner

Bert Wagner is a Business Intelligence Developer at Progressive Insurance. He enjoys solving challenging data transformations with T-SQL and optimizing for query performance. In addition to BI development, Bert loves building ASP.NET MVC web apps and building Internet of Things projects.

All authors

3 Things I Wish I Knew When I Started Using Entity Framework

by Bert Wagner

Bert Wagner

Entity Framework (EF) is Microsoft's object-relational-mapping tool (ORM) that allows programmers to easily map database objects to C# object models. What attracts developers to Entity Framework is the automatic...

2016-04-30

4 reads

All authors

Read the latest Blogs

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

Bert Wagner

3 Things I Wish I Knew When I Started Using Entity Framework

Blogs

A Broken Copilot Query

SQL Server Alerts

Prompt AI helping with Auditing

Forums

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

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

Was the index created or not?

Question of the Day

Estimated Rows