Archives for Software Dev - Page 48
Moving large tables to a different Filegroup
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 for being…
Find Largest Tables in your SQL Server database
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. CREATE TABLE…
Using Delegates in C#
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 in C…
How much memory does Windows Server 2008 R2 use?
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 Windows Server…
DataContractSerializer – MaxItemsInObjectGraph exceeded exception
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 a self-reference.…
nHibernate–manual session flushing
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 (as and…
Max Pool Size Setting in ADO.net
As part of my nHibernate troubleshooting, I decided to play with the max pool size setting in We had a WCF Service going through nHibernate – which was setup to…
Missing 4.5 IIS Application Pool, Upgrading to 4.5
Introduction If you have just upgraded to .NET for web app, you may be wondering how to ensure that your application actually is running on and not on the older…
SQL Server – Applying Database Tuning Advisor Recommendations
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 the trace…
A useful sql server (production) trace template
Introduction To run a sql server profiler session, you need a ‘trace template’. The default built-in templates are a good starting point (especially the ‘tuning’ template). However, a more advanced…