These tips apply broadly when writing high-performance stored procedures. Unfortunately, unlike some tips, you can't simply apply most of them without first considering the nature and schema of the data you're querying.1. Avoid using cursors (as well as other looping structures) as much as possible. Cursors are inefficient, and database engines usually don't have the best loop implementations in terms...
Wednesday, 30 January 2008
Tuesday, 29 January 2008
Passing datetime parameter to SQL Stored procedure in Query Analyzer
Yesterday I faced problem passing datatime parameter in sql server queryanalyzer, where I was trying to run a procedure UP_ORDER_LOG which expects parameter @co_id, @Prog_id, @event and @event_dateSo I tried executing the procedure likeexec UP_ORDER_LOG @co_id='XYZ', @prog_id='ABC', @event='Some event', @event_date=getdate()exec UP_ORDER_LOG @co_id='XYZ', @prog_id='ABC', @event='Some event', @event_date=getdateexec...
Thursday, 24 January 2008
ASP.NET Ajax Useful Links
ASP.NET AJAX 1.0http://www.microsoft.com/Downloads/details.aspx?familyid=CA9D90FA-E8C9-42E3-AA19-08E2C027F5D6&displaylang=enASP.NET AJAX Sampleshttp://download.microsoft.com/download/8/3/8/83889def-b71d-4cd7-9bea-44363d59b622/ASPAJAXSamples.msiAspNet AJAX Documentationhttp://ajax.asp.net/documentation/AspNet_AJAX_Documentation.zipASP.NET AJAX Control Toolkithttp://www.codeplex.com/Release/ProjectReleases.aspx?ProjectName=AtlasControlToolkitOther...
Difference Between .NET Framework 2.0 and .NET Framework 3.0
.NET Framework 3.0 = .NET Framework 2.0 + WCF + WPF + WF + WCSKirk Allen Evans has the best explanation so far of what comprises the .NET Framework 3.0. It can be summarized as:.NET Framework 3.0 = .NET Framework 2.0 + WCF + WPF + WF + WCSHe also has a diagram showing the different parts.Brad Abrams also tries to clear up the confusion by giving some more information .NET 3.0 and the "Orcas" release,...
Microsoft ASP.NET Futures (July 2007): Documentation and Resources
The Microsoft ASP.NET Futures July 2007 (“Futures”) release contains an early developer preview of features providing a wide range of new functionality for both ASP.NET, Dynamic Languages and Microsoft SilverlightTM. The functionality in the Futures release includes early experimental versions of features currently being considered for future versions of ASP.NET and the .NET Framework. The Futures...