How can I use the identity column, without knowing identity column’s name.
One of the most fun parts of blogging is when you learn something completely unexpected while writing a blog. The ... Continue reading
2022-05-12
2 reads
One of the most fun parts of blogging is when you learn something completely unexpected while writing a blog. The ... Continue reading
2022-05-12
2 reads
I’m actually hosting this month and I was wondering about your first technical job. Mine was kind of interesting. I ... Continue reading
2022-05-23 (first published: 2022-05-10)
172 reads
I’m actually hosting this month and I was wondering about your first technical job. Mine was kind of interesting. I ... Continue reading
2022-05-10
6 reads
No one knows everything. Ask any senior level person in IT and they’ll tell you that they spend plenty of ... Continue reading
2022-05-20 (first published: 2022-05-05)
428 reads
No one knows everything. Ask any senior level person in IT and they’ll tell you that they spend plenty of ... Continue reading
2022-05-05
8 reads
This month for TSQL Tuesday I’d like to hear about your first technical job(s). I know most DBAs don’t start ... Continue reading
2022-05-04 (first published: 2022-05-03)
54 reads
This month for TSQL Tuesday I’d like to hear about your first technical job(s). I know most DBAs don’t start ... Continue reading
2022-05-03
This Friday WITDC is having another Mental Health and Wellness Day virtual event and I’m part of a panel! This ... Continue reading
2022-04-05
21 reads
This Friday WITDC is having another Mental Health and Wellness Day virtual event and I’m part of a panel! This ... Continue reading
2022-04-05
Over the years, one of the best pieces of problem solving advice I’ve been able to give my kids is ... Continue reading
2022-03-31
562 reads
By Chris Yates
There was a time when the Chief Data Officer lived in the shadows of...
By Rayis Imayev
"But I don’t want to go among mad people," Alice remarked."Oh, you can’t help...
By Steve Jones
I saw some good reviews of the small gemma3 model in a few places...
Comments posted to this topic are about the item Create an HTML Report on...
Comments posted to this topic are about the item We Should Demand Better
Comments posted to this topic are about the item 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