Yep, make sense. Thanks.

Got to know something new today, though was confusing to me initially.

One can create Clustered & Non-Clustered ColumnStore Index but you can NOT add any constraints to it! Quoting from...

The original table has identity column. Does this help?

Select 1 as ID,4 ItemCount UNION ALL

Select 2 as ID,3 ItemCount UNION ALL

Select 3 as ID,5 ItemCount UNION ALL

Select 4 as ID,2...

Thanks Steve, it was very informative, like always.

thanks for the question. I really didn't know about this cool feature in sql 2012.:-)

Thanks for the question. It seems that the catch block is just for confusing 🙂 coz. the select query in the catch block doesn't execute

thanks for the good question.

good question, thanks.:-)

thanks for this wonderful article 🙂

Another "funny" thing is that BEGIN...END does not define the body of the procedure. You can have multiple BEGIN...END in the body of a procedure, like this:

create proc test

as

begin

...

got this simple question wrong!.... 🙁

thanks for this post 🙂

One question - will it be good to add a column instead - say IsWeekEnd, IsWeekStart. Will it fare better or worse than the current query...

even i got the same answer... lost my point today 🙁

nice question, thanks 🙂

good one, thanks Rahul...:-)

declare @myvariable as varchar, @len1 varchar, @len2 varchar

set @myvariable = 'hi hello how are you'

set @len1 = (select datalength(cast(@myvariable as char)))

print @len1

set @len1 = (select datalength(cast(@myvariable as...