shantanu's blog
Index in Sql Server
Submitted by shantanu on Wed, 01/06/2010 - 04:29Understanding Indexes
Indexes speed up the querying process by providing filtered access to rows in the data tables (just like book’s index) if they are used efficiently.
Indexes are created on columns in tables or views.
How to create a session variable in ASP.NET
Submitted by shantanu on Sat, 12/19/2009 - 13:38- Define an ASP.NET web site.
- Create two pages within the site. The first page will contain an ASP.NET Web Form that will post back to itself and then redirect to the second page.
Note: The reason this example uses two pages is to prove that a session variable is available to a second, third, fourth, etc. page in the web site. Request variables, which are an alternative to session variables, cannot be carried over from an ASP.NET Web Form on one page to a second page
"Create your own FTP Server" on Windows XP, Windows Server 2003 and Windows Server 2008
Submitted by shantanu on Wed, 10/28/2009 - 15:09Hi !
I was trying to create an FTP Server for last few days. After googling a lot I finally got the process of creating an FTP server, I would like to share this helpfull knowledge of creating ftp server.
You need to have a CD of your operating system.
For Windows XP
1. Start -> Control Panel -> Add or Remove Programs -> Add remove windows components. A window will appear.
"Error: 26 – Error Locating Server/Instance" Specified SQL Server
Submitted by shantanu on Tue, 10/27/2009 - 15:13“An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connection. (provider: SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified)”
This error might have occured due to the following reasons.
