Daily Archives: February 7, 2012

Interesting changes in Database Design of SQL Server 2012

Khilitchandra's Business Intelligence Blog Posted on by

Hi All, I would start this topic with a small real incident happened with me. I worked on SQL 2008 for almost 2.5 years and then I mixed my work with SQL 2008 R2. Once we had some work in SQL 2005 – SSIS package. It was a minor modification by playing with few date columns. I tried to use DATE datatype unknowingly and ssis package was giving me error. I did not concentrate on the DATE datatype which I have used and rather I was searching here and there. And finally I recalled that DATE datatype is not available … Continue reading →

My article got selected as “Article of Week” on BIDN :)

Khilitchandra's Business Intelligence Blog Posted on by

Hi folks, I would like to share a joy with you all that one of my articles got selected as “Article of Week” in BIDN. BIDN is “BI Developer Network Community“. Visit http://bidn.com for awesome BI articles and tutorials, If you are hungry to learn things from tech experts like Brian Knight, Dustin Ryan, Mike Davis, Devin Knight and many more…

Continue reading →

NOLOCK and With(NOLOCK)

Khilitchandra's Business Intelligence Blog Posted on by

Hi all, I want to share knowledge with you regarding NOLOCK and With (NOLOCK) hint in SQL queries we use in our day-to-day work/activities. According to MSDN, “In SQL Server 2005, with some exceptions, table hints are supported in the FROM clause only when the hints are specified with the WITH keyword. Table hints also must be specified with parentheses. The following table hints are allowed with and without the WITH keyword: NOLOCK, READUNCOMMITTED, UPDLOCK, REPEATABLEREAD, SERIALIZABLE, READCOMMITTED, FASTFIRSTROW, TABLOCK, TABLOCKX, PAGLOCK, ROWLOCK, NOWAIT, READPAST, XLOCK, and NOEXPAND. When these table hints are specified without the WITH keyword, the hints … Continue reading →