http://msdn.microsoft.com/en-us/library/ms189837.aspx
When SET NOCOUNT is ON, the count is not returned. When SET NOCOUNT is OFF, the count is returned.
The @@ROWCOUNT function is updated even when SET NOCOUNT is ON.
SET NOCOUNT ON prevents the sending of DONE_IN_PROC messages to the client for each statement in a stored procedure. For stored procedures that contain several statements that do not return much actual data, or for procedures that contain Transact-SQL loops, setting SET NOCOUNT to ON can provide a significant performance boost, because network traffic is greatly reduced.
Monday, September 20, 2010
Tuesday, September 14, 2010
Tailspin Spyworks
1. Beginner Developer Learning Center
http://msdn.microsoft.com/en-us/beginner/default.aspx
2. Tailspin Spyworks Step-by-Step Tutorial - demonstrates how extraordinarily simple it is to create powerful, scalable applications for the .NET platform. It shows off how to use the great new features in ASP.NET 4 to build an online store, including shopping, checkout, and administration.
This tutorial series details all of the steps taken to build the Tailspin Spyworks sample application.
http://www.asp.net/web-forms/tutorials/tailspin-spyworks-part-1
http://msdn.microsoft.com/en-us/beginner/default.aspx
2. Tailspin Spyworks Step-by-Step Tutorial - demonstrates how extraordinarily simple it is to create powerful, scalable applications for the .NET platform. It shows off how to use the great new features in ASP.NET 4 to build an online store, including shopping, checkout, and administration.
This tutorial series details all of the steps taken to build the Tailspin Spyworks sample application.
http://www.asp.net/web-forms/tutorials/tailspin-spyworks-part-1
Friday, September 3, 2010
AJAX
From http://www.telerik.com/help/aspnet-ajax/ajxajax.html -
AJAX-enabled applications, on the other hand, rely on a new asynchronous method of client-server communication. It is implemented as a JavaScript engine that is loaded on the client during the initial page load. From there on, this engine serves as a mediator that sends only relevant XML-formatted data to the server and subsequently processes the server response to update the relevant page elements.
Below is a diagram of the complete lifecycle of an AJAX-enabled web form.
Click to enlargeClick to enlarge
1. Initial request by the browser – the user requests a particular URL.
2. The complete page is rendered by the server (along with the JavaScript AJAX engine) and sent to the client (HTML, CSS, JavaScript AJAX engine).
3. All subsequent requests to the server are initiated as function calls to the JavaScript engine.
4. The JavaScript engine then makes an XmlHttpRequest to the server.
5. The server processes the request and sends a response in XML format to the client (XML document). It contains the data only of the page elements that need to be changed. In most cases this data comprises just a fraction of the total page markup.
6. The AJAX engine processes the server response, updates the relevant page content or performs another operation with the new data received from the server. (HTML + CSS)
AJAX-enabled applications, on the other hand, rely on a new asynchronous method of client-server communication. It is implemented as a JavaScript engine that is loaded on the client during the initial page load. From there on, this engine serves as a mediator that sends only relevant XML-formatted data to the server and subsequently processes the server response to update the relevant page elements.
Below is a diagram of the complete lifecycle of an AJAX-enabled web form.
Click to enlargeClick to enlarge
1. Initial request by the browser – the user requests a particular URL.
2. The complete page is rendered by the server (along with the JavaScript AJAX engine) and sent to the client (HTML, CSS, JavaScript AJAX engine).
3. All subsequent requests to the server are initiated as function calls to the JavaScript engine.
4. The JavaScript engine then makes an XmlHttpRequest to the server.
5. The server processes the request and sends a response in XML format to the client (XML document). It contains the data only of the page elements that need to be changed. In most cases this data comprises just a fraction of the total page markup.
6. The AJAX engine processes the server response, updates the relevant page content or performs another operation with the new data received from the server. (HTML + CSS)
Thursday, September 2, 2010
Monday, August 30, 2010
ProXPN
http://www.youtube.com/watch?v=ONpttV7o9Oc&feature=player_embedded
ProXPN is a new VPN service which creates a highly secure environment between your computer and the internet.
ProXPN is a new VPN service which creates a highly secure environment between your computer and the internet.
Friday, July 9, 2010
Thursday, July 8, 2010
Understand the Attraction of Small Functions
From http://petesbloggerama.blogspot.com/ -
Bill Wagner, in his excellent book, “Effective C#” Second Edition (which I reviewed here), gives a good example in his “Item 11 – Understand the Attraction of Small Functions”:
Bill says that one of the most common examples of premature optimization is when you create longer, more complicated methods in the hope of avoiding method calls.
The .NET Runtime performs JIT compilation on a method – by – method basis at runtime, as the methods are used. Methods that do not ever get called don’t get JITed. Bill gives a short example:
public string BuildMsg( bool takeFirstPath )
{
StringBuilder msg = new StringBuilder( );
if ( takeFirstPath )
{
msg.Append( "A problem occurred." );
msg.Append( "\nThis is a problem." );
msg.Append( "imagine much more text" );
} else
{
msg.Append( "This path is not so bad." );
msg.Append( "\nIt is only a minor inconvenience." );
msg.Append( "Add more detailed diagnostics here." );
}
return msg.ToString( );
}
The first time BuildMsg gets called, both paths are JITed, but only one is needed. But if you rewrote the method this way:
public string BuildMsg( bool takeFirstPath )
{
if ( takeFirstPath )
{
return FirstPath( );
} else
{
return SecondPath( );
}
}
-- the body of each clause has been factored into its own method, and that method can be JITed on demand rather than the first time BuildMsg is called. The example is deliberately short and contrived, but think about how you code: Do you write code with 20 or more statements in each branch? How about switch statements where the body of each case block is defined inline instead of in separate methods?
Bill Wagner, in his excellent book, “Effective C#” Second Edition (which I reviewed here), gives a good example in his “Item 11 – Understand the Attraction of Small Functions”:
Bill says that one of the most common examples of premature optimization is when you create longer, more complicated methods in the hope of avoiding method calls.
The .NET Runtime performs JIT compilation on a method – by – method basis at runtime, as the methods are used. Methods that do not ever get called don’t get JITed. Bill gives a short example:
public string BuildMsg( bool takeFirstPath )
{
StringBuilder msg = new StringBuilder( );
if ( takeFirstPath )
{
msg.Append( "A problem occurred." );
msg.Append( "\nThis is a problem." );
msg.Append( "imagine much more text" );
} else
{
msg.Append( "This path is not so bad." );
msg.Append( "\nIt is only a minor inconvenience." );
msg.Append( "Add more detailed diagnostics here." );
}
return msg.ToString( );
}
The first time BuildMsg gets called, both paths are JITed, but only one is needed. But if you rewrote the method this way:
public string BuildMsg( bool takeFirstPath )
{
if ( takeFirstPath )
{
return FirstPath( );
} else
{
return SecondPath( );
}
}
-- the body of each clause has been factored into its own method, and that method can be JITed on demand rather than the first time BuildMsg is called. The example is deliberately short and contrived, but think about how you code: Do you write code with 20 or more statements in each branch? How about switch statements where the body of each case block is defined inline instead of in separate methods?
Wednesday, June 9, 2010
Performance - Patterns and Practices
Big list of links related to Performace -
http://blogs.msdn.com/b/jmeier/archive/2010/06/08/patterns-amp-practices-performance-guidance-roundup.aspx
http://blogs.msdn.com/b/jmeier/archive/2010/06/08/patterns-amp-practices-performance-guidance-roundup.aspx
Friday, May 28, 2010
regex to strip non-numeric characters from a phone-number-string
javascript - function(value) {return value.replace(/[^0-9]/g,"") }
This convertor function strips any non-numeric characters from the INPUT element. Now, if you enter the phone number (206) 555-9999 into the phone input field then the value 2065559999 is assigned to the phone property of the contact object
http://weblogs.asp.net/scottgu/archive/2010/05/07/jquery-templates-and-data-linking-and-microsoft-contributing-to-jquery.aspx
This convertor function strips any non-numeric characters from the INPUT element. Now, if you enter the phone number (206) 555-9999 into the phone input field then the value 2065559999 is assigned to the phone property of the contact object
http://weblogs.asp.net/scottgu/archive/2010/05/07/jquery-templates-and-data-linking-and-microsoft-contributing-to-jquery.aspx
Thursday, May 20, 2010
Sunday, March 28, 2010
Deep Zoom related
Deep Zoom - automating the generation of collection -
1. http://www.codeproject.com/KB/silverlight/DecosDeepZoom.aspx
2. http://blogs.msdn.com/giorgio/archive/2008/05/05/deep-zoom-batch-export-programmaticly-using-c.aspx
1. http://www.codeproject.com/KB/silverlight/DecosDeepZoom.aspx
2. http://blogs.msdn.com/giorgio/archive/2008/05/05/deep-zoom-batch-export-programmaticly-using-c.aspx
Saturday, March 27, 2010
Script.aculo.us - useful effects
Here we insered to extra parameters. In this example, the picture will start fading after 10 seconds, not frames, and will only fade to 50 percent of it's original color.
>
Here are all the 16 standard effects that you can use with script.aculo.us:
Fade: Decreases opacity
Appear: Increases opacity
BlindUp, BlindDown: Changes height of the element
SlideUp, SlideDown: Slides the element up or down.
Shrink: Resizes the element( Shrinks)
Grow: Resizes the element( Expands)
Highlight: CHanges background color of element.
Shake: Causes an element to slide left to right a few times.
Pulsate: Rapidly fades in and out several times.
DropOut: Simultaneously fades an element and moves it downward, so it appears to drop off the page
SwitchOff: SImulates an old television bieng turned off; a quick flicker, and then the element collapses into a horizontal line.
Puff: Makes an element incease in size while decreasing opacity.
Squish: Similiar to shrink, but the element's top-left corner remains fixed.
Fold: First redurces the element's height to a thin line and then reduces its width until it disappears
>
Here are all the 16 standard effects that you can use with script.aculo.us:
Fade: Decreases opacity
Appear: Increases opacity
BlindUp, BlindDown: Changes height of the element
SlideUp, SlideDown: Slides the element up or down.
Shrink: Resizes the element( Shrinks)
Grow: Resizes the element( Expands)
Highlight: CHanges background color of element.
Shake: Causes an element to slide left to right a few times.
Pulsate: Rapidly fades in and out several times.
DropOut: Simultaneously fades an element and moves it downward, so it appears to drop off the page
SwitchOff: SImulates an old television bieng turned off; a quick flicker, and then the element collapses into a horizontal line.
Puff: Makes an element incease in size while decreasing opacity.
Squish: Similiar to shrink, but the element's top-left corner remains fixed.
Fold: First redurces the element's height to a thin line and then reduces its width until it disappears
Thursday, March 25, 2010
JavaScript Tutorial: Regular Expressions
Very Good Javascript Tutorial
JavaScript Tutorial: Regular Expressions
JavaScript Tutorial: Regular Expressions
Sunday, March 14, 2010
Saturday, March 13, 2010
QuirksMode - for all your browser quirks
QuirksMode - for all your browser quirks: "QuirksMode.org is the prime source for browser compatibility information on the Internet. It is maintained by Peter-Paul Koch, mobile platform strategist in Amsterdam, the Netherlands.
QuirksMode.org is the home of the Browser Compatibility Tables, where you’ll find hype-free assessments of the major browsers’ CSS and JavaScript capabilities, as well as their adherence to the W3C standards."
QuirksMode.org is the home of the Browser Compatibility Tables, where you’ll find hype-free assessments of the major browsers’ CSS and JavaScript capabilities, as well as their adherence to the W3C standards."
Thursday, March 11, 2010
Wednesday, March 10, 2010
Saturday, February 13, 2010
Wednesday, February 10, 2010
ASP.Net stuff to learn
6 Things Every ASP.NET Developer Should Know by 2010 -
http://blog.saviantllc.com/archive/2009/03/09/4.aspx
(read comments for other suggestions)
patterns & practices: App Arch Guide 2.0 Knowledge Base
http://www.codeplex.com/wikipage?ProjectName=AppArch&title=App%20Pattern%20-%20Three-Tier%20RIA%20Application%20Scenario
http://blog.saviantllc.com/archive/2009/03/09/4.aspx
(read comments for other suggestions)
patterns & practices: App Arch Guide 2.0 Knowledge Base
http://www.codeplex.com/wikipage?ProjectName=AppArch&title=App%20Pattern%20-%20Three-Tier%20RIA%20Application%20Scenario
Subscribe to:
Posts (Atom)