Tag Sql

26 Sep 2010

NHibenate and Varchar(Max) 4k limit

From a little bit of research with the release of SQL 2005, the Text and NText have been;deprecated;in favour for VarChar(Max) and NVarChar(Max).However I was observing a issue when using VarChar(Max), each time I saved more than 4k bytes of data int Read more
17 Mar 2008

Finding out the connection type of your Client Apps

It can be helpful to know how and what ports your application connects to the MS SQL server. Ok maybe not, but i was in a pickle and needed to find this information out. What I was looking for was all the connections I had open to a SQL server from a Read more