Time for another episode of the SQL Friday, The Best SQL Server Links Of The Past Week show.
Here is what I found interesting this past week in SQL Land:
A DBA utility database in every SQL Server instance?
Linchi Shea writes: I was reading Louis Davidson’s post earlier today, and what he said below caught my attention:
I am a big believer in having the database be as self contained as possible, so I try to put [maintenance] objects and such in the database, typically in a schema named utility.
This is different from what I typically do, and got me wondering how people out there managing their maintenance objects. I typically store all the maintenance objects in a dedicated database on every SQL Server instance across the enterprise
SQL Server: What is a COLD, DIRTY or CLEAN Buffer?
What is clean buffer? What is cold buffer cache? The PSS SQL Server Engineers explain the difference
Set based calculation of products of several numbers
Alexander Kuznetsov shows us how we can use use SUM to calculate the sum of several numbers, but you cannot directly use set-based logic to calculate a product. Yet there is a very simple trick – you can use EXP(SUM(LOG(…))) and get a product of several numbers without a loop
That is it for this week, I will tag the weekly posts with SQL Friday in case you want to see the whole archive in the future