Error List Manager 1.1 is available with more export options

I just released Error List Manager 1.1 with new Export templates. In this version new HTML and PDF templates are added.

Read more from Error List Manager page.

Supported HTML Templates

Below listed HTML files are generated using different ELM HTML Templates.

Export Visual Studio's Error List as HTML

Export Visual Studio Error List as HTML

Export Error List from Visual Studio

Export Visual Studio's Error List as HTML

Save Error List from Visual Studio Error List Toolwindow

Supported PDF Templates

Export Visual Studio' Error List as PDF

Email

Using this option you can directly send the Error List items as an attchment in Outlook email client. If oulook is already running then make sure that Visual Studio and Outlook runs with same access rights.

Emailing Visual Studio's Error List using ELM

Print

This option will send the Error List to the default printer. You can change any default settings from Print settings window as per your requirement.

Printing Visual Studio's Error List using ELM

Advertisements

jQuery – .bind(), .live(), .delegate(), .on() ( and also .unbind(), .die(), .undelegate(), .off() )

Confused, Which one to use, jQuery .bind(), .live(), .delegate(), .on() - Shemeer

The .bind() method registers the type of event and an event handler directly to the DOM element. The .bind() doesn’t work for elements added dynamically that matches the same selector. This method is pretty easy and quick to wire-up event handlers. The shorthand methods like .click(), .hover(), etc make it even easier to wire-up event handlers. There is a performance issue while working with large selection as the method attaches the same event handler to every matched element in the selection.The attachment is done upfront which can have performance issues on page load.

The basic difference between .bind() and .live() is bind will not attach the event handler to those elements which are added/appended after DOM is loaded and there is only one event handler registered instead of the numerous event handlers that could have been registered with the .bind() method. When using .live() events always delegate all the way up to the document. This can affect performance if your DOM tree is deep. Chaining is not properly supported using .live() method. Using event.stopPropagation() is no longer helpful because the event has already delegated all the way up to the document. .live() method is deprecated as of jQuery 1.7 and removed from jQuery 1.9.

The .delegate() method is very powerful, The difference between .live() and .delegate() is, live function can’t be used in chaining. live function needs to be used directly on a selector/element. Also .delegate() works on dynamically added elements to the DOM where the selectors match. Chaining is supported correctly in .delegate().

The .on() method attaches event handlers to the currently selected set of elements in the jQuery object. As of jQuery 1.7, the .on() method provides all functionality required for attaching event handlers. Brings uniformity to the various event binding methods. but as the the way we call .on() method the behaviour also changes.

Note: If you are using jQuery 1.7+ then its advised to use .on() for attaching events to elements or selectors.

Read more from CodeProject.

The Solution User Options (.Suo) File in Visual Studio

What is Solution User Options (.suo) file

The solution user options (.suo) file is a structured storage, or compound, file stored in a binary format. This file is used to store user preference settings, and is created automatically when Visual Studio saves a solution.

Location of .suo file

The .suo file will be saved in the folder where your Solution (.sln) file exists. You might wanted to set true for “Show Hidden Files and Folder” in “Folder Options” as .suo file is default by hidden.

What informations are saved in my .suo file

This file is used by Visual Studio to store user/solution specific information such as Opened Files, Expanded Nodes in the Solution Visual Studio .suo fileExplorer, Opened Tool Windows and its Positions, User Tasks, Breakpoints, Start-up Project, Contents of Watch window, Whether the project is loaded/unloaded  etc. The same file is used by Visual Studio Addins (VSPackages) to persist information that are specific to that solution/user.

.suo file and Source Control

Adding user specific information to source control is not a good idea. Most of the code versioning control ignores .suo file by default. If included, the developer, who checks out the latest .suo file, will loose all his personal settings which is stored in the local .suo file.

Visual Studio performance and .suo file

If the size of .suo file is too large then it can affect the performance of Visual Studio. Deleting the .suo file will boost the performance.

Deleting .suo file

Visual Studio creates a new file with the .suo file extension as soon as you open again the solution. But once the file with the .suo file extension is deleted, any of your existing solution user-specific settings will be lost.

App_Offline.htm, an easy way to take asp.net web application offline

You can simply take down an ASP.NET 2.0 or later application offline temporarily by uploading a file called App_Offline.htm in the root of a web application directory.  While the App_Offline.htm file exists, any requests to the Web site are redirected to this file. The file displays a friendly message that tells clients that the Web site is being updated or down due to some reasons.

This is very handy when we do deployments manually. We just need to put App_Offline.htm file in root directory of web application and the ASP.NET runtime will detect the existence of  App_Offline.htm, if it exists, then the ASP.NET runtime will shut-down the application, unload the application domain from the server, and stop processing any new incoming requests for that application.  ASP.NET will also then respond to all requests for dynamic pages in the application by sending back the content of the App_Offline.htm file

When all Web site files have been copied, you can delete the App_offline.htm. Once removed, the next request into the application will cause ASP.NET to load the application and app-domain again, and all things will continue to work as normal.ASP.NET Web Site Application Offline

Most of the automated publishing tools or options also takes advantage of App_Offline.htm

Note: Always make sure that your App_offline.htm page is at least 512 bytes by adding filler tags or hidden text or comments as In Internet Explorer if  “Show Friendly Http Errors”  is set to true, and a server returns a non HTTP-200 status code with less than 512 bytes of content, IE will not show the returned HTML and instead substitutes its own generic status code message. In IE6 “Show Friendly Http Errors” is set to true by default.

SQL Server – Table Hints

Table hints are nothing but a Transact-SQL clause that is specified in the FROM clause of the data manipulation language (DML) statement and affect only the table or view referenced in that clause. Table hints override the default behavior of the query optimizer for the duration of the data manipulation language (DML) statement by specifying a locking method, one or more indexes, a query-processing operation such as a table scan or index seek, or other options.

Because the SQL Server query optimizer typically selects the best execution plan for a query, msdn recommend that hints be used only as a last resort by experienced developers and database administrators.

Microsoft-SQL-Server

Using hints can add a performance penalty and hints that improved performance in earlier editions of SQL Server may not do so in newer versions. However, there are situations where a hint can improve performance or allow queries to execute that would otherwise be blocked

Syntax:-

WITH  ( <table_hint> [ [, ]...n ] )

<table_hint> ::= 
[ NOEXPAND ] { 
    INDEX  ( index_value [ ,...n ] ) | INDEX =  ( index_value )    | FORCESEEK [( index_value ( index_column_name  [ ,... ] ) ) ]
  | FORCESCAN
  | FORCESEEK
  | HOLDLOCK 
  | NOLOCK 
  | NOWAIT
  | PAGLOCK 
  | READCOMMITTED 
  | READCOMMITTEDLOCK 
  | READPAST 
  | READUNCOMMITTED 
  | REPEATABLEREAD 
  | ROWLOCK 
  | SERIALIZABLE 
  | SPATIAL_WINDOW_MAX_CELLS = integer
  | TABLOCK 
  | TABLOCKX 
  | UPDLOCK 
  | XLOCK 
} 

<table_hint_limited> ::=
{
    KEEPIDENTITY 
  | KEEPDEFAULTS 
  | HOLDLOCK 
  | IGNORE_CONSTRAINTS 
  | IGNORE_TRIGGERS 
  | NOLOCK 
  | NOWAIT
  | PAGLOCK 
  | READCOMMITTED 
  | READCOMMITTEDLOCK 
  | READPAST 
  | REPEATABLEREAD 
  | ROWLOCK 
  | SERIALIZABLE 
  | TABLOCK 
  | TABLOCKX 
  | UPDLOCK 
  | XLOCK 
}

Omitting the WITH keyword is a deprecated feature: This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

Separating hints by spaces rather than commas is a deprecated feature: This feature will be removed in a future version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible.

Sample:

SELECT * FROM Employees WITH (NOLOCK)

Click here to read more from MSDN