Monthly Archives: September 2012

What is binding and how many types of bindings are there in WCF?

  By Gaurav Agrawal | September 30, 2012 - 12:57 PM |
Leave a comment

A binding defines how an endpoint communicates to the world. A binding defines the transport (such as HTTP or TCP) and the encoding being used (such as text or binary). A binding can contain binding elements that specify details like the security mechanisms used to secure messages, or the message pattern used by an endpoint. WCF supports nine types of bindings. Basic binding Offered by the BasicHttpBinding class, this is designed to expose a WCF service as a legacy ASMX web service, so that old clients can work with new services. When used by the client, this binding enables new WCF … Click here to continue reading. →

How to follow the coding standards across the team?

  By Gaurav Agrawal | September 29, 2012 - 12:48 PM |
Leave a comment

If you have a team of different skills and tastes, you are going to have a tough time convincing everyone to follow the same standards. The best approach is to have a team meeting and developing your own standards document. You may use this document as a template to prepare your own document. Distribute a copy of this document (or your own coding standard document) well ahead of the coding standards meeting. All members should come to the meeting prepared to discuss pros and cons of the various points in the document. Make sure you have a manager present in … Click here to continue reading. →

What is an execution plan? When would you use it? How would you view the execution plan?

  By Gaurav Agrawal | September 28, 2012 - 12:43 PM |
Leave a comment

The Query Analyzer has a feature called Show Execution Plan. This option allows you to view the execution plan used by SQL Server’s Query Optimizer to actually execute the query. This option is available from the Query menu on the main menu of Query Analyzer, and must be turned on before the query is executed. Once the query is executed, the results of the execution plan are displayed in graphical format in a separate window, available from a tab that appears below the query results window on the screen.

What is the difference between a Local temporary table and a Global temporary table? How is each one used?

  By Gaurav Agrawal | September 27, 2012 - 12:41 PM |
Leave a comment

Answer1: Local templrary table will have a single # (#tablename) appended with the table name.Global templrary table will have Double # (##tablename) appended with the table name. Ex:create table #table1 local temp. table will be available until the session who created it logs out, but global temp. table is available till the last session gets close in SQLServer. Answer2: Local temporary tables are visible only in the current session; global temporary tables are visible to all sessions.Prefix local temporary table names with single number sign (#table_name), and prefix global temporary table names with a double number sign (##table_name).