Archives for Language features, Development Methodologies - Page 17
Upload entire solution into TFS–first time
Right click solution - Add Solution to Source Control Now, all the files will show up in TFS with a + sign - they have been 'added' but not 'checked…
The quickest way to compare two lists (for matching entries–i.e. duplicates)
In Excel (2007 and above), place each list of values in its own column. Now, Select cells in first list, then hold CTRL key and then select the second Go…
Filesystem notes from the real world–C#
These are just some quick tidbits about file processing in C#. Reading in files, reading in LARGE files, Reading and Processing Large Files. Reading a file (use a StreamReader) if…
Overall Strategy for Monitoring SQL Server Performance
This is just a quick cliff’s notes on what to look for in terms of the Physical Design of the database. The four main categories of concern are : Memory…
Nasty Joins, Cartesian Joins
A Cartesian join is an (incorrect) join between two tables. Incorrect because the tables have not been joined in any relational street_address from authors a, location b where like ‘%varma%’…
Sql Server Enterprise versus Standard Editions
High Availability SQL Server Standard includes some features to enable high availability, but the Enterprise edition brings more. Features like database snapshots, mirrored backups and fast restore mean that when…
Visual Studio – VS find matching brace
1. Place your cursor either before or after the OPENING brace. 2. Type CTRL ] (CTRL and CLOSE BRACKET) – it should jump to the closing brace
WCF – The maximum string content length quota (8192) has been exceeded while reading XML data
Introduction The DataContractSerializer in WCF serializes objects to XML Streams. There is a size (length) limitation on these streams. They are restricted by default to 8k (8192 bytes). While this…
Visual Studio Using Too Much Memory
When running by itself (no project opened and no extensions), Visual Studio 2012 takes less than 100 MB. When you open up your projects, those add to the total memory…
Using Database Tuning Advisor for individual queries
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…