Using of ThreadStatic attribute for static fields...

Sorry guys could not get back soon due to work. My take is ANSI_PADDING affects only storage not comparisons.I thought it would be a good blog topic so please go through below for details and examples [http://beyondrelational.com/modules/2/blogs/381...

Sorry guys could not get back soon due to work. My take is ANSI_PADDING affects only storage not comparisons.I thought it would be a good blog topic so please go through below for details and examples [http://beyondrelational.com/modules/2/blogs/381...

Sql server ignores trailing spaces while comparing using WHERE and HAVING clauses .However this behavior is different for LIKE clause....

wow....never knew a space has so many things in sql server(also I am wondering if a space deserves this much variation and thus attention)... thanks nakul,vadivel,Patrick and mitesh... I will have to go through the examples mentioned before any reply...

wow....never knew a space has so many things in sql server(also I am wondering if a space deserves this much variation and thus attention)... thanks nakul,vadivel and mitesh... I will have to go through the examples mentioned before any reply...

In part 1 and part 2 we learned about NULL propagation , ISNULL,COALESCE, tristate logic etc. Now let’s learn few remaining parts. ...

create table #temp ( a varchar(10) ) insert into #temp values(' a ') select COUNT(*) from #temp where a=' a' select COUNT(*) from #temp where a='a' first query will return 1 2nd will return 0 as sql ser...

insert into #temp values(' ##########a##################### ') original post didnt allowed me spaces so '#' is a placeholder for space...

insert into #temp values(' ##########a##################### ') original post didnt allowed me spaces so '#' is a placeholder for space...