.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Try your optimizing skills on Phil Factor Speed Phreak challenge

Posted By:      Posted Date: September 03, 2010    Points: 0   Category :Sql Server
Can you provide a better solution to this problem? So far nobody has been able to come up with a non-cursor based T-SQL solution. http://ask.sqlservercentral.com/questions/17499/phil-factor-speed-phreak-challenge-6-the-stock-exchange-order-book-state-problem Johan Åhlén http://blogical.se/blogs/jahlen

View Complete Post

More Related Resource Links

Try your SQL CLR optimization skills on Phil Factor Speed Phreak challenge

Who can provide a better solution to this problem? http://ask.sqlservercentral.com/questions/17499/phil-factor-speed-phreak-challenge-6-the-stock-exchange-order-book-state-problem Johan Åhlén http://blogical.se/blogs/jahlen

Optimizing speed for generating repeating table (Programming)


Hi everyone,

I have an Infopath 2010 form which has a repeating table generated by programming.

It works fine with few records in our database, but if the record has several hundreds row, it is taking really long time to generate the form.

Here is the code part for generating the table:

  /* XPath Navigators */

  XPathNavigator FirstSource = MainDataSource.CreateNavigator();
  XPathNavigator site = FirstSource.SelectSingleNode("/my:myFields/my:group1/my:group2/my:field1", NamespaceManager);
  XPathNavigator department = FirstSource.SelectSingleNode("/my:myFields/my:group1/my:group2/my:field2", NamespaceManager);
  XPathNavigator expenseCode = FirstSource.SelectSingleNode("/my:myFields/my:group1/my:group2/my:field3", NamespaceManager);
  XPathNavigator oracleCode = FirstSource.SelectSingleNode("/my:myFields/my:group1/my:group2/my:field4", NamespaceManager);
  /* Display Query */
  string str = "SELECT swsite,swdepartment,adpexpenseCode,O

Speed SQL: Tuning Your Database Calls with Tier Interaction Profiling


Tier interaction profiling (TIP) is a feature of the Visual Studio profiling tools that measures the duration of synchronous calls to ADO.NET-compliant data stores. We'll show you how TIP works and provide some best practices for using TIP to diagnose performance problems in your apps.

Mark Friedman

MSDN Magazine August 2010

Lessons Learned: Optimizing A Large Scale Software + Services Application


Udi Dahan explains how his team identified and overcame unforeseen problems while developing a large-scale software + services trading application.

Udi Dahan

MSDN Magazine April 2009

Built For Speed: Develop Turbocharged Apps For Windows Compute Cluster Server


This article explores the services provided by Compute Cluster Server 2003 and the tools provided by Visual Studio 2005 that will help you develop High-Perfomance Computing applications.

Rich Ciapala

MSDN Magazine April 2006

Speed: NGen Revs Up Your Performance with Powerful New Features


In the .NET Framework 2.0, NGen has been greatly improved and offers a number of compelling new features to make it easier and faster to deploy high-performance managed applications. This article introduces some of these new features and explains how and when you should use NGen to improve the performance of your apps.

Reid Wilkes

MSDN Magazine April 2005

Vrooooom: How .NET and C# Drove an Entry in the DARPA Grand Challenge


Find out how the .NET Framework, a team of programmers, and a bunch of people from Carnegie Mellon University built an automated car to compete in the DARPA Grand Challenge. Along the way you get some inside tips on building an extensible real-time control architecture based on a whiteboard metaphor and implementing an accurate GPS-synchronized timer component for .NET.

John Hind

MSDN Magazine December 2004

ASP.NET 2.0: Speed Up Your Site with the Improved View State in ASP.NET 2.0


View state is a wonderful thing. It allows the ASP.NET developer to maintain state for server-side controls that are not form elements.Used judiciously, it can improve the user experience. But in the wrong hands, it can cause your pages to grind to a halt. The release of ASP.NET 2.0 will include a variety of improvements to view state that will make it easier to use and less likely to slow performance.

Fritz Onion

MSDN Magazine October 2004

Resource File: Skills Development


Two Microsoft Web sites have been created to assist developers in writing secure code using the latest technology.

MSDN Magazine September 2002

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend