Lessons learnt from the world of Software Development, Object Oriented Design and .NET Architecture.
Often times, instead of tuning an entire database, we are interested in performance tuning a single offending query. This can be accomplished by applying the tuning wizard to a specific query as shown below:
From within Query Analyzer, select ‘Analyze Query … Continue reading
This is just a quick note to highlight a commonly used web testing metric for making an initial determination of where the source of bottleneck(s ) might be.
Most commonly, testers measure the total response time for a web page. … Continue reading
From a DOS prompt, type echo %USERNAME% /domain . This should return your username as registered in the current domain.
Full Domain Name
I can never remember the full domain name – an easy way to look it up is to type … Continue reading
nHibernate is still one of the most popular ORM layers in use today. It provides support for collections, advanced querying, caching, statement batching, automatic change tracking for entities and more, making it one of more mature ORM layers in use. … Continue reading
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 convert any of your projects to compile against 4.0 (by setting the … Continue reading
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 moved to their own filegroup (see appendix below for ‘ how … Continue reading
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 #FindLargeTables
table_name sysname ,
row_count … Continue reading
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 – and other languages). In C#, there are three things to … Continue reading
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 2008 Enterprise or Windows Server 2008 Datacenter
Maximum (64-bit systems):32 GB (for … Continue reading
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.
public Person(string firstName, string lastName, Person parent)