Geeks With Blogs
Dheeman Dutta Just Another Blog..... July 2006 Entries
When to use CLR Integration in SQLServer 2005
As it is well known that MS SqlServer 2005 has CLR integration feature to it. Now what campe up straight to my mind was when to use what , i.e when to use T-SQL and when to use CLR compaitble sp.I got the following thumb rule from a book (Introducing MS SQlServer 2005 for Developers), I'm just specifying them. If the code primarily accesses or modifies data , it should be written in T-SQL . CLR code can never match the DML feature of normal T-SQL. If the code mainly contains processor intensive operations ......

Posted On Thursday, July 27, 2006 6:19 AM

Performing Update And Insert In One Statement in SqlServer 2005
MERGE INTO MyTable USING MYTempTable ON MyTemptable.MatchingField1=... WHEN MATCHED THEN UPDATE updatefield1=MyTemptable.up... WHEN NOT MATCHED THEN INSERT VALUES(mytemptable.matching... ......

Posted On Thursday, July 27, 2006 4:13 AM

SQlServer 2005 varchar/nvarchar datatype size
I've heard that SQLServer 2005 has introduce 2GB of data to its varchar,nvarchar datatypes. That was cool. But when I tried the foll. code Declare @var varchar(max) set @var=replicate('A',16000) Print len(@var) It gave me 8000. I'as preety flammoxed. then i cam accross the fact that these datatypes increase with a fixed size of 8000. so i tried the foll. Declare @var varchar(max) set @var=replicate('A',8000) set @var =@var + replicate('A',8000) Print len(@var) this gave me 16000 ......

Posted On Thursday, July 27, 2006 3:12 AM

PageBaseType
pageBaseType is an extremely powerful setting that you might to use when all your application pages inherit from a common class. it is in the section of the web.config.

Posted On Sunday, July 23, 2006 11:08 AM

Debugging during Remoting when general debug statements are not hit
To break into a remote object, you have to put this line of code.

System.Diagnostics.Debugger.Break;

Posted On Wednesday, July 12, 2006 6:38 AM

Calling WebServices Dynamically in .NET

I was trying to find out if I can call an webservice fully dynamically , even without adding static web reference , when I cam across this article.

http://www.topxml.com/WS-web-services/re-32258_Dynamically-Invoking-a-Web-Service.aspx

An excellent article

Posted On Friday, July 7, 2006 7:42 AM

Response.Redirect Giiving ThreadAbortException

http://groups.google.com/group/microsoft.public.vsnet.debugging/msg/31af5f195763a69b?q=ThreadAbortException+response.redirect&hl=en&lr=lang_en&ie=UTF-8&oe=UTF-8&rnum=1

Posted On Wednesday, July 5, 2006 9:26 AM

Copyright © Dheeman Dutta | Powered by: GeeksWithBlogs.net