Browse by Tags

All Tags » Tips (RSS)
Saturday, June 23, 2007 7:29 PM

Computing Time Difference

While Sql Server provides functions to manipulate datetime data types(DateDiff, DateAdd etc.) they don't have(as far as I know) functions to manipulate time. Very useful when computing time differences. In the past I had to manually datediff parts...
Posted by bonskijr | 2 comment(s)
Filed under: ,
Tuesday, April 17, 2007 5:09 PM

Sql Server Data Type Precedence : Redux

Previously jokiz bloged about this one , I'd like to add further. The same issue cropped up again in the forums although not the exactly the same as jokiz's experience, this one could really give you hours of head scratching. Previously I was amazed that...
Posted by bonskijr | 5 comment(s)
Filed under: , , ,
Sunday, April 08, 2007 8:12 PM

Using ConnectionString section in NHibernate

Finally NHibernate (1.2+) is able to take advantage of .NET2.0's connectionStrings section, which previously I'd have to either declare it twice (in either config file or the dedicated hibernate.cfg.xml) All you need to do is, instead of using...
Posted by bonskijr | 1 comment(s)
Filed under: ,
Thursday, March 01, 2007 3:11 PM

Sql Server: How To Restore A Non-Production DB Faster

Today I was preparing the DB for an implementation of one our module app, I brought along a soon to be production DB . The DB itself was not that big (5GB), however restoring it was taking alot of time. Normally I wouldn't worry about it, but I was on...
Posted by bonskijr | with no comments
Filed under: ,
Monday, February 26, 2007 11:50 AM

Getting rid of .svn folders

I often copy several OSS projects that I have checked out from their public Subversion repository, back at home so that I have the "bleeding edge" source when working. I find it a hassle to have to include all the .svn files. John Galloway presented a...
Posted by bonskijr | 2 comment(s)
Filed under: ,
Sunday, December 10, 2006 9:47 AM

Sql Server 2005 Tip:Implicit Conversion of bit data types

Didn't you know that the following statement is now valid for Sql Server 2005 as criteria for a column with bit data type? SELECT * FROM Orders WHERE Processed = 'true' The engine is now intelligent enough to implicitly convert it to SELECT * FROM Orders...
Posted by bonskijr | 2 comment(s)
Filed under: , ,