A Journey...called LIFE....

OK!! Finally I have convinced myself to write some technical stuff in my personal blog.. anyhow we work in that industry right and spend most of our time and eventually life coding and reading about technology, so here you go guys my first ever blog on technology - Below are some of the tips to optimize Stored Procedure with making simple changes in the code. -Include SET NOCOUNT ON statement: With every SELECT and DML statement, the SQL server returns a message that indicates the number of affected rows by that statement. This information is mostly helpful in debugging the code, but it is useless after that. By setting SET NOCOUNT ON, we can disable the feature of returning this extra information. For stored procedures that contain several statements or contain Transact-SQL loops, setting SET NOCOUNT to ON can provide a significant performance boost because network traffic is greatly reduced. CREATE PROC dbo.ProcName AS SET NOCOUNT ON; --Procedure code here SELECT column1 FROM dbo.Tbl...

Find Face book Statistics as below, I am really wondering now how much money & time people have.. WOW!! AMAZING!!!!!!!! Company Figures More than 350 million active users 50% of our active users log on to Facebook in any given day More than 35 million users update their status each day More than 55 million status updates posted each day More than 2.5 billion photos uploaded to the site each month More than 3.5 billion pieces of content (web links, news stories, blog posts, notes, photo albums, etc.) shared each week More than 3.5 million events created each month More than 1.6 million active Pages on Facebook More than 700,000 local businesses have active Pages on Facebook More than 20 million people become fans of Pages each day Pages have created more than 5.3 billion fans Average User Figures Average user has 130 friends on the site Average user sends 8 friend requests per month Average user spends more than 55 minutes per day on Facebook Average user clicks the Like button on 9...