Products of MajikbyboB

SQL Server Compression Estimator MajikbyboB 

Internet \ Server

One of the most exciting additions to SQL Server 2008 was the capability to apply data compression. The benefits are many including reduced disk I/O and memory utilization, with a small cost of CPU overhead. In a database that may contain thousands of objects, determining which objects and / or partitions of those objects may benefit from data. Freeware download of SQL Server Compression Estimator, size 641.73 Kb.


SQL Iterators 1.0 MajikbyboB 

Internet \ Server

There are several undocumented stored procedures that many DBAs rely on to do their day to day work - namely spMSForEachDatabase and spMSForEachTable. This project is a SQL-CLR assembly that provides equivalent functionality to those two stored procedures. These stored procedures support pre and post commands, as well as up to three. Freeware download of SQL Iterators 1.0, size 104.86 Kb.