Deleting millions of records from a table without blowing the transaction log
Over the weekend I realized that deleting 80% of the records on a table with 87 million rows is not quite as easy as issuing a delete statement with a where ...
Over the weekend I realized that deleting 80% of the records on a table with 87 million rows is not quite as easy as issuing a delete statement with a where ...
I spent a couple of hours searching for a script that returns the size of all the tables in a database. Most of the ones that you find use sp_msforeachtable ...
So we went clay shooting yesterday with Adam Tyler (an Athen’s Olympic Bronze medalist and two time Commonwealth Gold medalist) showing us how it’s done. A...
It’s been nearly four months since I moved to Melbourne and having been in Sydney six months prior, Melbourne was indeed a welcome change. Although it’s very...
So I wanted to find a tool that would do fast folder comparisons. Searching on Google gave me a lot of useless stuff most of them related to fast folder acce...
I’ve been wanting to start a personal blog for sometime and finally went ahead with it. This post though is not about my personal blog but rather about whic...
This is what I wanted my automated build to do: Get the latest version from CodePlex Update the version number in AssemblyInfo.cs Build the projec...
I wound up work on my last project and thought of sharing some performance challenges we faced when the product went live. Keep in mind though that optimizat...
Silverlight 2.0 just went live. If you are a .NET developer building ASP.NET or WinForms/WPF applications this is a HUGE deal. Your .NET code can now r...
For a long time I've been searching for the ultimate note taking application. OneNote used to be my favorite but since I became a consultant and needed to mo...