By Sumit Gupta on January 19, 2012
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 good to not having case sensitive search by default, as except password compare you most often doesn’t need case sensitive search. Do you? well I [...]
Posted in Database, MS SQL Server, SQL | Tagged COLLATE, Password Protection, Search, SQL, SQL Server |
By Sumit Gupta on September 8, 2011
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 his effort of writing and Connection everytime. Everything works great during our development and online reviewing. However as soon as we lauch website in beta [...]
Posted in .NET, ASP.NET, C#.NET, Concept/algorithm, Database, VB.NET/VB | Tagged ASP.NET, SQLConnection, Static Object |
By Sumit Gupta on August 15, 2011
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. It has quite a few steps before I achieve a acceptable speed with database and here is list of those that need to be taken [...]
Posted in SQlite | Tagged Bulk Insert, Data Management, SQL, SQLite |
By Sumit Gupta on July 12, 2011
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 related dynamic database tables. But the problem was in part where we preload user information and later show them on our dynamic forms when user [...]
Posted in Database, MS SQL Server, SQL | Tagged Optimzation, SQL Query |
By Sumit Gupta on May 7, 2011
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. DBCC CHECKIDENT (<TableName>, RESEED, 0) Works great for me on Sql Server 2008
Posted in Database, MS SQL Server, SQL | Tagged SQL, SQL Server |
By Sumit Gupta on April 25, 2011
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% on windows [some 372% on linux]. Looks great work by them. But I found this information funny, as my some Open source lover friends always [...]
Posted in Joyous, MySQL, Operating System | Tagged Mysql, Open source, Windows |
By Sumit Gupta on December 13, 2010
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, but that error was not very clear on specific reason of fault. After searching for articles and forums, I got a hint that in past [...]
Posted in MySQL, Server Configuration | Tagged crash, Mysql, Upgrade |
Recent Comments