Top 100 interview question and short answers

By Sigar Dave No comments

Q1. Explain the differences between Server-side and Client-side code? Ans. Server side code will execute at server (where the website is hosted) end, & all the business logic will execute at server end where as client side code will execute at client side (usually written in javascript, vbscript, jscript) at browser end. Q2. What type […]

Top 100 interview question and short answers

By Sigar Dave No comments

Q1. Explain the differences between Server-side and Client-side code? Ans. Server side code will execute at server (where the website is hosted) end, & all the business logic will execute at server end where as client side code will execute at client side (usually written in javascript, vbscript, jscript) at browser end. Q2. What type […]

Why Disabling Error Report in Windows is Not a Cool Idea?

By Sigar Dave No comments

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, […]

Why Disabling Error Report in Windows is Not a Cool Idea?

By Sigar Dave No comments

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, […]

Passing datetime as a parameter to SQL Stored procedure in Query Analyzer

By Sigar Dave No comments

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 […]

Passing datetime as a parameter to SQL Stored procedure in Query Analyzer

By Sigar Dave No comments

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 […]

Tips for Writing High-performance SQL Query

By Sigar Dave No comments

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 […]

Tips for Writing High-performance SQL Query

By Sigar Dave No comments

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 .NET Framework 3.5 Namespaces Chart

By Sigar Dave No comments

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

Microsoft launches DreamSpark: Indian students get access to technical software at no charge

By Sigar Dave No comments

– 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 […]