SQL University: Advanced Indexing – Indexing Strategies
Right, I know it’s Friday and everyone’s tired and looking forward to the weekend, but I do need to finish...
2011-11-11
1,584 reads
Right, I know it’s Friday and everyone’s tired and looking forward to the weekend, but I do need to finish...
2011-11-11
1,584 reads
Welcome back to day 2 of Advanced Indexing. Today we’re going to look at a feature that was added in...
2011-11-09
1,933 reads
Good day everyone and welcome to another week of SQL University. I know we’re getting close to the end of...
2011-11-07
2,679 reads
I finally found the time to work through the questions from the 24 Hours of PASS session that I did....
2011-09-27
749 reads
I want to spend some time over the next few months looking at query compilation and the plan cache, and...
2011-08-16
3,584 reads
Coming to the PASS Summit in October this year? Excellent!
I say excellent, because Grant (blog|twitter) and I are presenting a...
2011-08-09
767 reads
Just short of the winter solstice, I bailed out of a freezing cold Johannesburg for warmer climates; well, actually for...
2011-07-22
1,248 reads
When I looked at indexing for queries containing predicates combined with OR, it became clear that the are some restrictive...
2011-07-05
1,617 reads
This should be another quick one.
Earlier I saw a forum post where someone asserted that SQL always executes an update...
2011-06-21
4,800 reads
So we’re supposed to talk about disasters we’ve had or discuss disaster recovery technologies. I’m going to take a slightly...
2011-06-14
731 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