Tags » T-SQL

A brute-force approach to a Bin Packing Problem using T-SQL

The Bin Packing Problem concerns the allocation of items of varying size into a finite number of containers, there are many variations on this problem as well as related problems such as the… 703 more words


Percent progress reporting in T-SQL

Occasionally I’ll need to execute something in a T-SQL loop and if the number of iterations is significant or the process is long-running – I might want progress messages to be reported back to SSMS. 97 more words


View your Failover Cluster from the DMV's

Just a quick post this time , I was fumbling around the DMV’s the other day looking for a specific Availability group DMV that I just couldn’t remember the name of – I think we have all been there before with some of the DMV names! 223 more words