Posted: 02 Sep 2010 08:40 AM PDT In order to make Windows stable, Microsoft comes with an error reporting tool which is enabled by default. Every time a program crashes, a window pops up asking you to send diagnostic information to Microsoft. For those lucky souls who have never come face to face with it, […]
Posted: 02 Sep 2010 08:40 AM PDT In order to make Windows stable, Microsoft comes with an error reporting tool which is enabled by default. Every time a program crashes, a window pops up asking you to send diagnostic information to Microsoft. For those lucky souls who have never come face to face with it, […]
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_date So I tried executing the procedure like exec 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 UP_ORDER_LOG @co_id='XYZ', @prog_id='ABC', @event='Some event', @event_date=CURRENT_TIMESTAMP […]
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_date So I tried executing the procedure like exec 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 UP_ORDER_LOG @co_id='XYZ', @prog_id='ABC', @event='Some event', @event_date=CURRENT_TIMESTAMP […]
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 […]
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 […]
Microsoft released a new poster that provides you a nice overview of the common types and namespaces in the .NET Framework 3.5 at a single glimpse. You can download a PDF version of the poster here Posted by Brij
– Access to software developer and designer tools to students at no charge – DreamSpark includes: o Visual Studio 2005/2008 Professional Edition, o Expression Studio (includes Web, Blend, Media and Design), o SQL Server 2005 Express, SQL Server 2005 Developer Edition, o Windows Server 2008 Standard Edition, o XNA Game Studio 2.0 and o 12-month […]
Microsoft released a new poster that provides you a nice overview of the common types and namespaces in the .NET Framework 3.5 at a single glimpse. You can download a PDF version of the poster here Posted by Brij
– Access to software developer and designer tools to students at no charge – DreamSpark includes: o Visual Studio 2005/2008 Professional Edition, o Expression Studio (includes Web, Blend, Media and Design), o SQL Server 2005 Express, SQL Server 2005 Developer Edition, o Windows Server 2008 Standard Edition, o XNA Game Studio 2.0 and o 12-month […]
