View Complete Post
I have a stored procedure where the performance is bad. The Execution plan shows 5 table scans each of cost 12%. The data is being pulled from the table using the following where clause.
where (datestamp>getdate() - 'sep28 1902 12:00 AM')
I already have an index on Datestamp column but still Table scan is happening. There is no restriction on avoiding index is specified in the query.
If the index is place inappropriately there would be index scan but here I have table scan.
Could anyone help me in finding out why this is happening.
I've a problem while using ASP.My situation is I want to convert every documents' contained words into database and upload those document to server.For example: MS word, MS Power Point, MS Front Page and PDF files.Those words needed to store into database and let others to search by content.Thank You !
I have query that behaves much differently the moment I modify the Where clause
The following query runs fast!!
We need to use SharePoint Virus Scan API and implement IMso_VirusScanner interface. However, not sure of how to go about. Where, in which namespace can we get this interface? Or we need to download it specially?
I am trying to restore SS2000 database backup .BAK (full backup) on to SQL Server 2005 and at then end SSMS throws an error
System.Data.SqlClient.SqlError: Could not continue scan with NOLOCK due to data movement. (Microsoft.SqlServer.Smo).
Any help will be appreciate on this.
How i can do that? I wanna that detect a scanner and you can push a Scan Button.
The query is using a index scan not seek.... how can I get it to use a seek.
I am using SQL 2005
i run the IBM APP SCAN vulrunrability tool on my site it is giving me following attacks
1)Cross site request forgery attack (how can we fix it and how that tool is doing this attack on a particurlar site, i didnot understand if anybody knows you can explain me)
2) sql injection ( for this we done parameterised queries, but that tool still showing that blind sql injection is there ? how is it possible after using parameter queries? )
3)Http header injection ( what is workaround for this)
but i didnt understand one thing how that tool is performing the above attacks , if anybody had experience the above problems let me know. ( if anybody worked on the APP SCAN TOOL let me know)
Burepalli V S Rao.
Hello SP Community,
My organization is planning to upgrade it's MOSS 2007 build to SPS 2010. As part of the prep for that upgrade we will run the pre-upgrade scan. I have two questions:
1). How effective is the pre-upgrade scan at really identifying issues?
2). What types of MOSS 2007 customizations would most likely create problems for the upgrade?
Hi,I have the following error with a MBSA 2.1 scan on a server running Windows Server 2008 SP2 and SQL server 2008:
"CmdExec role. Error reading registry. If you are scanning a remote computer the Remote Registry service on that computer should be enabled. (13)"
I amÃÂ running a local scan. Any idea how to fix the issue?
I have a simple query to select all coumns from a table where primary key column in (list of values). The primary key has clustered index on primary key column. The query was executing very effieicntly until recently (have around 4
million rows in the table and growing steadily around 8-10K rows per month). Recently this query became a bottleneck (takes 45 secs to a min to execute) when I looked at the plan it was doing index scan on clustered primary key column index instead of
index seek, I checked on index fragmentation it was 1.48 percent.
I created a new non clustered unique index on primary key column with all other columns in include part of the index (coverage index) and created execution plan, it said index seek on new index, when i executed the query it executed in less than
a sec (8milli secs to be precise), I thought everything was fine and executed the same query again this time it took 45 secs again, I looked at the plan it says index scan on the new index I created.
This trend continues every time I drop and re-create the new index it does index seek first time and switches over to index scan when I execute the same query after the first try. I am totally confused and would like to know what is causing the issue.
Any help is highly appreciated. Thanks in advance for any help.
I have a requirement where i need to check the virus of a file when uploading file to server. Actually we don't know what type of files user uploads, he may upload a word doc which has virus. So inorder to protect server i need to write a program which should help in rejecting the file which has virus.
I try to use the code sample from code project inorder to execute scan documents :
It works on Windows-XP and not working on Windows-7.
1. Is there is any specification on windows-7 that should be considered ?
2. Why the code is now working on windows-7, Can you supply me sample code that works on windows-7 ?