Hi folks I am not blogging frequently as I am busy in some of my personal stuff ,. Hope I will be blogging more in this month. Now following is list of monthly post in last month October 2011 Following are link of my SQL Server Mentalist Blog 5 bas...

Hi all, After long time I have started sharing,analyzing scripts again.. I just believe on sharing knowledge rather than keeping it to myself folks.. I will also suggest you to do same and see the difference between world and you !! Lets get back to...

Hi friends Continuing from my last post on same series also we have completed following topics in my previous post as follows : BISQL # 72 – Laymen to SQL Developer # 3 – Assignment #1 – Part #2 – Why DBMS or What are Limitations of file processin...

Hi friends Continuing from my last post on same series also we have completed following topics in my previous post as follows : BISQL # 72 – Laymen to SQL Developer # 3 – Assignment #1 – Part #2 – Why DBMS or What are Limitations of file processi...

Hi folks , Continuing from my last post on same series also we have completed following topics in my previous post as follows : BISQL # 76 – Laymen to SQL Developer # 5 – Assignment #1 – Part #4 – What is Data Independence and All information rela...

Hi folks, As I am not posting on Administrative Configuration aspect of SQL Server I thought of posting some scripts and explanation on  Security,Rights,Logins and many more In this post we are going to have explanation for following seniors ...

Hi friends , Today I just thought of explain and doing some research on  global variable ,and my post is also on same topic. In SQL Server Global Variable series we are going to looked in following as future post . SQL Server Global Variable...

Hi Folks, Lets continue from my last post on Global variable SQL Server Global Variable #1 - Introduction of Global Variable SQL Server Global Variable #2 - Global Variable 12 of 36 (This post) SQL Server Global Variable #3 - Global Variabl...

Hi friends After a week I am blogging on SQL Server Blog. I have already provided blogs on time as follows BISQL # 3 :Time and Date Query code and Analysis Part –I Hope I will be regular from onwards !! In this article we will just see few conver...

Hi friends Today just off the track I m posting some Stored Procedure Optimization Tips Following is Summery of Stored Procedure optimization Include SET NOCOUNT ON Use of sp_executesql instead of EXECUTE Naming Convention shoul...