Archives for Language features, Development Methodologies - Page 18
Visual studio does not display .NET 4.0 (or 4.5) framework option for target framework
Introduction Even if you have .NET framework (or above) installed correctly, Visual Studio sometimes does not pick it up. This means that you will be unable to convert any of…
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…
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.…
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…
Sending Large SOAP messages in WCF
This is just a quick tip. Remember SOAP runs over HTTP – and just changing the SOAP configuration (basicHttpBinding or wsHTTPBinding configuration) is not enough for sending large SOAP messages…
Inserting code snippets into MS Word documents
Step 1 – Insert Object from MS Word’s INSERT menu. Select OBJECT from the drop-down (as opposed to ‘Text from file’). Step 2 – You should see an ‘Object’…
Message Based versus RPC Style Services
Choose Message-Based Programming Over RPC Style You can design Web services by using either of two programming models: messaging style and RPC style. The RPC style is based on the…