Archives for Language features, Development Methodologies - Page 18
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…
Source file ‘\Properties\AssemblyInfo.cs’ could not be opened (‘Unspecified error ‘)
Introduction You’ve just downloaded a project (from either codeproject or github or some other repository) – and opened it up in your current version of Visual Studio. On trying to…