|
Do you run into a timeout when you do a SELECT instead of a DELETE? E.g. SELECT COUNT(ID) FROM bml... etc.? And how many entries are to be deleted?
Are there indices for the ID columns in both tables?
Are there any constraints, e.g. an OnDeleteCascade?
|
|
|
|
|
id is uniqueness and
and one entries finally will be deleted.
and i don't have any constraint on bml table
thanks in advanced
|
|
|
|
|
Your subquery should not select "all" columns, only the ID-column.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
ok
i use select id instead of select * but im still face with timeout
i think that this is because of that my nested select return an empty column
what you thinks ?
how can i handle this problem?
thanks for answer
|
|
|
|
|
mhd.sbt wrote: i use select id instead of select * but im still face with timeout A command-timeout or a connection-timeout? How long does the query take when run on the server directly?
Can you post the schema of the tables here? It would be weird if you'd select the same key that you're filtering on.
mhd.sbt wrote: what you thinks ? I'm pretty sure that you can select "where in null" without hitting performance-problems of said magnitude.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
thanks for your time to answer this problem.
i found problem
that i posted it in a solution
|
|
|
|
|
Personally, I don't like sub-selects (they seem so 90s), I'd rather JOIN them.
(Provided your system allows it)
-- Transact-SQL extension
USE AdventureWorks2012;
GO
DELETE FROM Sales.SalesPersonQuotaHistory
FROM Sales.SalesPersonQuotaHistory AS spqh
INNER JOIN Sales.SalesPerson AS sp
ON spqh.BusinessEntityID = sp.BusinessEntityID
WHERE sp.SalesYTD > 2500000.00;
|
|
|
|
|
I have installed SQLServer2008R2 on my Windows 7
PC successfully.
However, when I open the configuration manager,
the "SQL Server Services" entry shows an error message saying
"The remote procedure call failed 800706be".
|
|
|
|
|
|
Hi all
In c# forum i asked the below question
Hi all
Please clear my doubt.
I have one server system where i installed sql server.
5 client machines accessing that.
now suppose if there is any power fluctuation like it's coming for 5 min and again going and so on.
So for this kind of situation, how to save the data or how to update the database each second.??
Is it possible that at a time we update the client database also and server database also.?
i.e at button click it should update both client and server database..
Please help..
Then i got the suggestion of database mirroring / database replication.
I am very much new to this.
Please need suggestion from you guys.
|
|
|
|
|
Code-Hunt wrote: Please need suggestion from you guys.
Google the topic. And buy a book or perhaps two.
Then set up some test servers. And test it. After you figure out the pro/cons of the possible different ways to do this.
Naturally of course would also need to consider other types of failures, which means that you need the two server located in different geographic areas. That of course means you must not only consider the methodology of replication but the cost. And find hosting companies to host at least on of the servers.
You must also test it and insure that the servers continue to run in production.
With the cost you might also consider the possibility that doing all of this yourself might not only cost a lot (if you are being paid) but will also have a high risk. Consequently finding a hosting service that provides all of the above but be more effective.
|
|
|
|
|
Get a UPS[^] for all affected systems including switches.
Be excellent to each other. And... PARTY ON, DUDES!
Abraham Lincoln
|
|
|
|
|
And what sort of answer is that, it has nothing to do with databases, he did not ask for a solution to his problem he wanted to know about mirroring
I feel like an idiot for not thinking of that!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I believe someone didn't get the sarcasm, (over)compensating.
Be excellent to each other. And... PARTY ON, DUDES!
Abraham Lincoln
|
|
|
|
|
Code-Hunt wrote: now suppose if there is any power fluctuation like it's coming for 5 min and again going and so on.
So for this kind of situation, how to save the data or how to update the database each second.?? That cannot be solved by software, you'll need an UPS. It's simple; if the power to your server is cut when it is writing, the system might die and no longer boot.
Code-Hunt wrote: So for this kind of situation, how to save the data or how to update the database each second.?? That'd hardly help; how long does your server take to boot? You reckon' it had time to rollback a failed transaction?
Code-Hunt wrote: Is it possible that at a time we update the client database also and server database also.? Yes. Take your IDbCommand-code (the block where your C# is executing the SQL), and press Ctrl-C and Ctrl-V. Simply execute every command twice, once to your server, and a local copy.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Dear All,
May i know how to direct link a pdf file from server ?
i had tried as below code but doesnt work ,kindly advise, thank you
<iframe
src="file://10.238.15.14/Level3ACMKSOP$/SOP Master Copy(PDF)/Human Resource/MKZHR-01-001(Organization Management Policy ACMY)/MKZHR-01-001(V000)%20Organization%20Management%20Policy%20ACMY.pdf#toolbar=0&navpanes=0&statusbar=0&view=Fit">
|
|
|
|
|
I think you picked the wrong forum for this, it has nothing to do with Database.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hi all, I am trying to display the results of a left outer join between two tables on my web app but there seems to be problems with my stored procedure. I have tried to put the results of the left outer join into a new table by using the following stored procedure:
USE [Payable]
CREATE PROCEDURE [dbo].[getEmployeeData]
AS
BEGIN
SELECT *
INTO NewTable
FROM Employees
LEFT OUTER JOIN Hourly_Employees
ON Employees.Employee_ID_PK = Hourly_Employees.Hourly_Employee_ID
END
Please point out why it does not work, thanks in advance.
|
|
|
|
|
What results are you expecting? What happen when you run the select statement on SQL Studio? If it were me, I will remove "INTO NewTable" statement, I assume the control on your web app will accept a DataDable or DataSet.
- If Employee_ID_PK and Hourly_Employee_ID are both Employee IDs and have correct DataTypes, then I see nothing wrong with the Stored Procedure. Run it on the SQL Studio and fix any error
I remain joe!
|
|
|
|
|
Assuming SQL Server
Take the select statement out of your proc into SSMS and confirm that your query returns results!
Why are you inserting the results into another table in the database when you want the results in your client.
Remove the INTO NewTable and the results will be returned to your calling command.
Explicitly return the columns you want rather than *.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
ASPnoob wrote: Please point out why it does not work
Because you are putting it into a table instead of returning it.
|
|
|
|
|
Hello All!
I am trying to debug someone else's stored procedure.
I see a RIGHT OUTER JOIN clause with no ON reference.
It goes in this form:
select
*
from
a inner join b on a.id=b.id
inner join c on a.id=c.id
right outer join e
inner join f on e.id = f.id
Strange part it is does not complain of syntax error.
When I try to re-write the same sql, it straight out errors out!
I don't know how the previous developer was able to compile the code!!
Thanks!!!
|
|
|
|
|
No idea, but which database system?
|
|
|
|
|
Assumption is that you are using SQL Server!
I often see this when using the query designer to create a view, I think it means e is not used in the data but is required get to f so the query builder simply does the join in this fashion.
I ALWAYS break this out and create the additional joins through to f, it is more understandable.
Caveat
This may be completely wrong (I never bothered to investigate the issue) and is probably technically incorrect but it is more readable.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Mycroft Holmes wrote: the query designer
Blech, filth.
|
|
|
|