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

*** If you have a SQL related question try our Microsoft SQL Server Programming forum or our Microsoft SQL Server Admin forum