InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 15:59:58 GMT20http://www.sqlservercentral.com/Forums/Topic940794-338-1.aspxPlease post query, table definitions, index definitions and execution plan as per [url]http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Tue, 22 Jun 2010 01:44:09 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic940794-338-1.aspxHI Gurus,In my appication I am tracking the visitors, who visited my profile, by their masked IP address.there are near about 20 Lakhs record in the table of Masked IP Address.At the end of every month I want to generate of visited profile.It takes to much time to fetch record by matchig Masked IP Address.Please tell me the soln how to handle with this situation?Thanks in advance.Tue, 22 Jun 2010 01:41:50 GMTniteen2009