Quick Hits on the News for Nov 12, 2007
A few comment on the database news for the week ending 11/10/07
2007-11-12
25 reads
Editorial
Wiggle Room
Consultants sometimes don't live up to their hype. To what extent should we expect them to know exactly what they're doing? This editorial was originally published on Nov 9, 2007. It is being republished as Steve is on vacation.
2012-08-08 (first published: 2007-11-09)
176 reads
2007-11-08
44 reads
Which Platform Do You Work On?
The growth of SQL Server's subsystems leaves Steve Jones wondering how should we be thinking about the product.
2007-11-07
121 reads
Whack a Database
The SQL Server team is looking for feedback on deleting databases and Steve Jones gives a few ideas.
2007-11-06
95 reads
2007-11-05
740 reads
The Personal Checksum
An interesting method of preventing restaurant fraud and a poll for other ways to determine the accuracy of data. This editorial was originally published on Nov 2, 2007. It is being republished as Steve is on vacation.
2012-08-30 (first published: 2007-11-02)
269 reads
Unstructured Data
I remember when Windows 3.1 started to gain widespread deployment in businesses. With all it's WYSIWYG features and multiple applications running at the same time, many people felt we'd get to a paperless office. Over a decade later I rarely see an office that doesn't have a copy machine and at least one printer. We've gotten better at shuffling bits, but we haven't gotten rid of paper.
2007-11-01
129 reads
2007-10-31
2,801 reads
October Energy Update
A recap of the world of energy from the previous two months. Steve looks at solar, wind, nuclear, and more.
2007-10-30
57 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