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 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 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 March 10, 2010
I was looking at MySQL.com and found a new GUI, which came as replacement of old MYSQL administrative GUI. My impression was not good to learn that they have something new, as I thought it might be just that they get their old interface opensourced or something. But when I install this application, hmm .. [...]
Posted in Database, MySQL | Tagged GUI, Mysql, SQL, WorkBench |
By Sumit Gupta on July 4, 2008
A useful like to know the reason of “Server has gone away” error of MySQL. http://blog.taragana.com/index.php/archive/mysql-tip-mysql-server-has-gone-away-or-lost-connection-to-server-during-query-fix/ It has very good information on why it happens, so you can check and correct the error.
Posted in Server Configuration, SQL | Tagged Database, Mysql, SQL |
Recent Comments