Thursday, 19 July 2007

Wednesday, 11 July 2007

Using LIKE statement in SQL Server

LIKE statement can be used in query if applican needs to match certain values in a database field.This article explains about using wildcards in LIKE statement. Also this will show example on regular expression usage in LIKE statement which should be handy for database admin.

Read more at:

http://www.dev-exchange.com/cms_view_article.php?aid=14

Tuesday, 3 July 2007

Database connection pooling in ADO.Net

Database performance may be getting affected if many users try to connect to it at same time. This article explains about how to improve database performance by using connection pooling in ADO.net. A connection pool is a cache or pool of database connections maintained by the application so that the connections can be reused when the database receives future requests for data. Have a look at this article to read more.


http://www.dev-exchange.com/cms_view_article.php?aid=12