If we use indices, performance will get reduced during insert and update statements. Hence i am trying to avoid index.
Is there any better way to refine this qurey??...
User Profile
Collapse
-
Query Performance
Hi,
If there are more than 15LAC records in the "cdetail" and "clm" table, Timeout exception occurs. Could anyone please help me in increasing the performance of this query: (Is there any way without using index)
[code=sql]
SELECT clm.ft, cdetail.clmid, cdetail.cline,
cdetail.servcod e, cdetail.revcode , clm.bccode,
clm.fycode FROM cdetail
INNER JOIN clm ON (clm.clmid = cdetail.clmid)... -
Yes, I have installed IIS 7.0 and FPSE 2002. The advanced settings are also set to %SYSTEM DRIVE%/Inetpub/wwwroot. Please help me to run the IDE :)...Leave a comment:
-
Web Application on Vista
hi,
I am running Visual Studio 2002 on Windows Vista (Enterprise edition). When i try to create a new web project , an error gets displayed like
"Unable to create project. the file path 'C:\inetpub\www root\foldername ' does not correspond to the URL "http://localhost/website". the two need to map to the same". This error is displayed. I have Frontpage extensions installed. I run the VS.net as Administrator. Please... -
.NET User Controls
Hi,
Why are User Controls code behind abstract, while Page code behind are not? Is there any specific reason behind this? -
User Controls in .NET
Hi,
Why are User Controls code behind abstract, while Page code behind are not? Is there any specific reason behind this? -
You could use String.Equals also. It determines whether two strings are having the same value.Leave a comment:
-
User controls abstract classes
Hi,
Why are User Controls code behind abstract, while Page code behind are not? Is there any specific reason behind this?
Thanks...
No activity results to display
Show More
Leave a comment: