Can You Dig It? – The Plan Cache
She can dig it!
D Sharon PruittIn this new series of posts, I plan to investigate the SQL Server plan...
2010-12-08
824 reads
StrateSQL
December PASSMN Meeting
Getting SQL Server for
Christmas! Happy holidays and seasons greetings!
True to fashion, the Minnesota SQL Server User Group (PASSMN) is...
2010-12-06
348 reads
SQLRally Call for Presenters
Go SQL! Go SQL! I haven’t blogged about it until now. If you weren’t aware, there’s a new conference in...
2010-12-06
373 reads
The Next 24 Hours of PASS
Calling for Presenters!PASS has announced the next 24 Hours of PASS and it will be on March 15 and 16. ...
2010-12-02
283 reads
Blog Round-up – What Are You Thankful For?
Last week I suggested to others that we institute a little idea theft and put together a few blog posts...
2010-11-29
2,195 reads
Do You Protect Your Passwords?
Protect Your Password! As a consultant, I am frequently receiving new passwords at clients and becoming aware of the password...
2010-11-26
673 reads
What Am I Thankful For
Earlier this week, I suggested that we share a message of thanks on our blogs. Since I suggested we put...
2010-11-26
964 reads
XQuery for the Non-Expert – Resources
Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post.
Talk to the Experts
Learning XQuery...
2010-11-24
1,599 reads
XQuery for the Non-Expert – Exist
Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post.
Talk to the Experts
In the...
2010-11-23
2,130 reads
Cry, Baby, Cry! Failing the MCM Test
Two things happened to me this morning. First, I woke up and took the written test for the SQL Server...
2010-11-22
755 reads
Blogs
From Data Custodian to Innovation Catalyst: The Evolving Role of the CDO
By Chris Yates
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 Rayis Imayev
"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 Steve Jones
I saw some good reviews of the small gemma3 model in a few places...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
We Should Demand Better
Comments posted to this topic are about the item We Should Demand Better
Estimated Rows
Comments posted to this topic are about the item Estimated Rows
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