This entry is going to be a collected list of practices for index, fragmentation, statistics, and general VLDB table and view maintenance. First off, a few obvious index practices. If a non-clustered index is not used, toss it. When a table has a record inserted, the duplicate of that is inserted into the non-clustered index.... Continue reading →

It seems that everywhere one looks in the ETL/OLAP/BI Industry Space there are no real canned applications. When I say canned application I’m talking about an application that from the ground up is all inclusive, managing the database, the ETL, the warehouse and any possible staging, and finally the Cube itself and reporting that sits... Continue reading →

Vista really is a lacking Microsoft Product. I’m not sure what the hell happened in comparison to Windows 2000 and XP. Both of those launches went rough, as usual, but not noticeably so. Vista however is just a dog within the industry these days. I’m sure it is even ceding a large number of customers... Continue reading →