XML Workshop 26 – SELECT * FROM XML
This article presents a generic function that makes it easy to query XML documents
Determining Object Access Using SQL Server Profiler
Deanna Dicken examines a SQL Server Profiler event to determine object access...who is using the object, when, and how. This gives the SQL developer or database administrator much needed information for impact analysis prior to a change or the decommissioning of a SQL Server object.
Generating a Distinct Delimited List Using XML
Generating an ordered, distinct, delimited string using ROW_NUMBER() and FOR XML PATH.
The Breakfast Plan Goes Awry
A simple motivational plan goes sideways in this guest editorial from Andy Warren.
Performance Counter DMV sys.dm_os_performance_counters
By querying a single DMV, sys.dm_os_performance_counters to be precise, you can collect counter information that you would receive from PerfMon for the various SQL Server counters.
How the Resource Governor Helped Our Report Server
Trying to manage the load in a reporting server can be hard. Roy Ernest shows that Resource Governor might be a great solution that has worked in his environment.
Kudos to the Community
Steve Jones takes a day to thank everyone that donates their time to help others in the community.
The Great Forum Debate
Phil discusses the pros and cons of the traditional versus stack overflow-style model for forum debate, and wonders whether there is a database model that would support all these different forms of discussion, or cooperative work, so that we can simply fit the 'visualization' to the nature of the particular discussion.
TSQL Challenge 33 - Calculate list of bookings fully paid on the book
This problem is related to a reservation system where customers book a service and pay it in one or more transactions which may happen on different dates.
Operator of the Week - Lazy Spool
Continuing to illuminate the depths of SQL Server's Query Optimizer, Fabiano shines a light on the sixth major Showplan Operator on his list: the Lazy Spool. What does the Lazy Spool do that's so special, how does the Query Optimizer use it, and why is it so Lazy? Fabiano Amorim explains all.
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