Mysql mostly provide a Case sensitive search because of its default collate configuration. However SQL server use different collate and hence by default it is not case sensitive. It is…
Category: Database
Static Object in ASP.NET
Recently I found a problem in one of application we developed. Here my colleague use a Static SqlConnection object through a class in his code. He did that to save…
SQLite Bulk Insert on ADO.NET
Today, I was trying to find an alternative on reading a Binary data file to use information in my software. For this I choose to use SQlite the embedded database….
Sql optimization
Today, I experience a slow down in one of website I just finish building up. It was a intereting project which has ability to create Dynamic form and hence the…
Reseed Auto Increment Value in SQL Server
You can reseed the Auto increment field to desire number by using following SQL statement [I think it is specific for SQL Server only] other Database have their own methods….
MySql 5.5 : funny about it
Just saw the release note of MySql 5.5. Looks exciting upgrade, but what looks most funny about the software is the fact that they claim to improve performance by 1500%…
MySQL : Crash and Upgrade
Today, I face a new problem with MySQL. I got the database to crash quite a few times since morning. Event logs shows that there is a fault in mysqld.exe,…