Vakul's .NET Realm

My journey towards .NET World…

  • Details

    Vakuls MCPD Certification Vakuls MCTS Certification Author's Pic



Posts Tagged ‘SQL Server 2005’

Links of the day – 11 September 2012

Posted by Vakul Kumar More on September 11, 2012

.NET / Visual Studio/Web Development
Inspirational
Quotes/Dictionary

Posted in ASP.NET, Technical, Useful Links | Tagged: , , , , , , , , , , , , , , , , , , , , , , | Leave a Comment »

Cursor Disadvantages

Posted by Vakul Kumar More on September 9, 2010

A conventional idea every experienced developer projects is : CURSOR is evil. Recently, I had a situation where I had to look into different options for achieving a task and many have said Cursors would the best option.

I started researching more on Cursors, as I was bit confused on contradictory ideas about cursors. A cursor is a memory resident set of pointers that reference data in your result set which has the data from the base tables. Cursors have a bad reputation because they are typically used by every Junior SQL Developer in search of an easy solution and they do not perform well and they deplete systems resources.

I personally feel SQL Server by default have a direct performance degradation on the usage of cursors. SQL ServerEngine processes records or data in such a way it will have a performance impact when cursor is used.  All other parallel processes will suffer when cursor is in action and they are the SLOWEST way to access data as it operates by checking row by row operations. Cursors are 30 times slower than any other alternatives.

I adopted an alternative way to accomplish my task.

Then why is Cursor needed ? There are few scenarios where we can use Cursors:

  • When you need to fire a stored procedure once per row in a table. In other words, if we need to perform row-by-row operations rather than set based operations
  • Query optimizer helps in achieving Adaptability and Efficiency by adapting itself.
  • When row wise validations are needed for less data.

I will keep on adding any new observations about Cursors in next few days.

Happy Coding

Posted in Technical | Tagged: , , , , , | 2 Comments »

SSRS Resources

Posted by Vakul Kumar More on January 4, 2009

To be successful in today’s competitive marketplace, organizations must extend information beyond the walls of their organization and seamlessly interact with customers, partners, and suppliers in real time. Microsoft SQL Server Reporting Services enables organizations to transform valuable enterprise data into shared information for insightful, timely decisions at a lower total cost of ownership.

image

SSRS Resources:

http://weblogs.sqlteam.com/joew/archive/2008/07/23/60656.aspx

http://prologika.com/CS/blogs/blog/archive/2008/07/21/a-must-read-reporting-services-blog.aspx

http://msdn.microsoft.com/en-us/library/ms160954(SQL.90).aspx

http://www.codeplex.com/SqlServerSamples/Release/ProjectReleases.aspx?ReleaseId=4000

http://technet.microsoft.com/en-us/library/ms170246(SQL.90).aspx

http://aspalliance.com/sql-reporting/

http://rtipton.wordpress.com/2008/08/09/sql-server-reporting-services-resources/#comment-855

http://blogs.msdn.com/bobmeyers/

Best learning resource:

http://www.simple-talk.com/sql/reporting-services/beginning-sql-server-reporting-services-part-4/

A Must-Read Reporting Services Blog :

http://prologika.com/CS/blogs/blog/archive/2008/07/21/a-must-read-reporting-services-blog.aspx

Posted in Technical | Tagged: , , , , | 1 Comment »