Introduction Even if you have .NET framework 4.0 (or above) installed correctly, Visual Studio sometimes does not pick it up. This means that you will be unable to…
Read more →
Introduction If you have some tables that are taking over 10% of the table space in SQL Server (see this post for finding large tables), they are candidates…
Read more →
Introduction This script uses a temp table to store the results of the query. It sorts the results in descending order – showing the largest tables on top.…
Read more →
Introduction Delegates encapsulate a method. All they do is provide an alternate way to call (‘invoke’) a method. This concept has been around for a while (function pointers…
Read more →
The maximum capacities for 32 bit and 64 bit Server OSes is listed below: Maximum (32-bit systems): 4 GB (for Windows Server 2008 Standard) or 64 GB (for…
Read more →
Simple Self Reference Consider the following class – a Person contains a list of Children – who are also Persons. So, Person references Person inside itself. This is…
Read more →
An nHibernate session maintains all changes to the object model. At some point, it needs to synchronize these changes with the database. It can either do these constantly…
Read more →
As part of my nHibernate troubleshooting, I decided to play with the max pool size setting in ado.net. We had a WCF Service going through nHibernate – which…
Read more →
Introduction If you have just upgraded to .NET 4.5 for asp.net web app, you may be wondering how to ensure that your application actually is running on 4.5…
Read more →
Once you have obtained a good ‘performance’ trace for your database, you can enlist the help of SQL Server’s tuning advisor. The advisor will treat the queries in…
Read more →