Browse: Home / Database / SQL

SQL

Case Sensitive Search in SQL Server

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 , , | Tagged , , , , | Leave a response

Sql optimization

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 , , | Tagged , | Leave a response

Reseed Auto Increment Value in SQL Server

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 , , | Tagged , | Leave a response

Pagination Query for SQL Server

By Sumit Gupta on June 17, 2009

In recent past, we got few problem when we need to do Pagination with SQL Server. I specially got frustrated when I saw that MySQL server has “limit” word that does pagination work in MySQL in best known manner for me, BUT microsoft didn’t consider that option yet. But today I found a method for [...]

Posted in , | Tagged , | 3 Responses

MySQL “Server has gone away” error

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 , | Tagged , , | Leave a response

Comparing Date Range (Date Interaction checking through SQL)

By Sumit Gupta on April 16, 2008

As title says, I was looking to compare User give date range with date range saved in mysql Database. I search internet and found a great  small function that solve this problem for me, though they create a function for some programming language but I use same function in mysql (as per mysql syntax) and [...]

Posted in , , | Tagged , , , | Leave a response

Creating SQL Table from another table

By Sumit Gupta on January 2, 2008

Often we need to take quick backup of database with data before we can make changes in table. for this I create the image of table within same database, as it is the fastest method. It is one of the reason why one need to create image a table.. or copy one table from another. [...]

Posted in , | 1 Response

Next »