very slow when i access table in SQLServer 2005

-

hi friends,

using sqlserver 2005. have table in project, has more 1 lakh records. when try access in front end, take more 4 mins.we have using join accessing table. need speed process.

thanks & regards

rajkumar

hello rajkumar,

have checked "execution plan" of query in ssms see, if proper indexes used query?
average data size per row of query? if it's large, needs time transfer data server client.

olaf helper

blog xing



SQL Server  >  SQL Server Data Access



Comments

Post a Comment

Popular posts from this blog

Top N or Bottom N filter based on a parameter

-
i have report parameter selection filtering data, either "highest" or "lowest".  if pick "highest" want top n, if "lowest" want bottom n.  how can set in filter ? j. way there many ways set report accomplish this. e.g asuming "n" fixed, you'll set report parameter has 2 hard-coded values "top" , "bottom" , based on user selects, can write report dataset query if (parameter value = "top") select top n ...... else if (parameter value = "bottom") select top n ......order <ordered column name> desc (again there other ways of doing too) else (whatever business logic needs go here, if @ all) if wanted keep n input parameter well, in addition above top/bottom filter, you'll add input filter (preferably free-text input) accept n , build dynamic sql string concatenating input parameter value in logic above. hope gets on right track. cheers! -muqadder. ...
Read more

KMS Activation Error 0xC004F056

-
Image
we're running kms server on windows 2008 r2 sp1 system. we've installed our server 2012-r2 key , applied hotfix 2885698. we're having problems activating server 2012 datacenter r2 systems. application logs, on clients, show attempting contact our kms server fail activate. our kms server licensing looks this: c:\windows\system32>cscript slmgr.vbs /dlv microsoft (r) windows script host version 5.8 copyright (c) microsoft corporation. rights reserved. software licensing service version: 6.1.7601.22449 name: windows server(r), serverenterprise edition description: windows operating system - windows server(r), volume_kms_2012-r2 channel activation id: dcb88f6f-b090-405b-850e-dabcccf3693f application id: 55c92734-d682-4d71-983e-d6ec3f16059f extended pid: 55041-00206-271-051856-03-1033-7601.0000-2952013 installation id: 017013793711071782473952179116233613374391945873535013 processor certificate url: http://go.microsoft.com/fwlink/?linkid=88342 machi...
Read more

Motherboard replacement

-
running windows 10 technical preview, need replace motherboard can run the  sysprep  command restoring pc ? or there easier  or more preferred way ? thanks if replace motherboard within same family of chipsets (i.e. intel > intel or amd > amd), should okay restarting pc twice. carey frisch Windows 10 Insider Preview  >  Windows 10 Insider Preview General
Read more