SQL Optimization Tips/Questions
Friday, December 4th, 2009Below are some of the tips for SQL query optimizations in the form of question/answers. 1. Which of the following query is the most optimized? a. SELECT column_name FROM table_name WHERE LOWER(column_name) = ‘name’. b. SELECT column_name FROM table_name WHERE column_name = ‘NAME’ or column_name = ‘name’. c. SELECT * FROM table_name WHERE LOWER(column_name) = [...] Read more »
Query to get a particular row in Sql Server 2005
Tuesday, May 19th, 2009In this article we will look into how to write a sql query to get a particular row in sql. Lets write the code to find 2nd row in a table named mcc_measures. So first we declare a temporary table declare @temp table (id int) No in this temp table we insertrow numbers of the [...] Read more »
Save Asp.NET Session state in SQL Server
Tuesday, May 5th, 2009Session states of the asp.net application can be easily saved into SQL Server using the following steps: Change the settings in the web.config file. <sessionState mode= allowCustomSqlDatabase="true" cookieless="false" timeout="20" sqlConnectionString= "database=Test_globalBms ; user id=abc;password=abc123$;server=172.27.68.1 " /> In the database create the appropriate tables.It is done automatically wen we execute the exe aspnet_regsql.exe located at C:\WINDOWS\Microsoft.NET\Framework\v2.0. [...] Read more »
