-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Kapil Blogs

Hi friends, I am Kapil Singh Kumawat and I am from Jaipur in Rajasthan, India. I have been working with SQL Server for the last four and a half years and am currently working with Cognizant Technology Solutions as an SQL Server Developer. I have experience in performance tuning, SSIS, data migration, database designing and writing queries. My other interests include travelling, watching football and listening to music.

Archives: April 2015

Find blocking using sp_who in SQL Server

Hi friends, in this blog I will tell you how can we find blocking using sp_who system stored procedure. Also, …

Continue reading Read more

0 comments, 200 reads

Posted in Kapil Blogs on 22 April 2015

How index gets dropped in Views in SQL Server

Hi Friends, In this blog I am going to tell about dropping of indexes in view in SQL Server. Views …

Continue reading Read more

2 comments, 182 reads

Posted in Kapil Blogs on 18 April 2015

How CONCAT_NULL_YIELDS_NULL behave with computed columns In Sql Server

Hi friends, in this blog I am going to tell you about effect of CONCAT_NULL_YIELDS_NULL for computed columns while creating …

Continue reading Read more

0 comments, 132 reads

Posted in Kapil Blogs on 18 April 2015