I am developing a website in ASP.NET with SQL SERVER as backend.
I want to find the best(FASTEST) way by which I can find if USERNAME exists or not.
My application is taking a bit of time finding that out. Do I need to look into my TABLE structure,indexes.
Is there any replacement for the query
Select username from usermaster where username=@Username
View Complete Post