The tag has no wiki summary.

learn more… | top users | synonyms

3
votes
2answers
410 views

select() hangs due to resource exhaustion - but what resource?

Connecting to my server via sftp sometimes results in a hang here: if (select(max+1, rset, wset, NULL, NULL) < 0) { which is line 1428 from openssh 5.2p1's sftp-server.c (main loop of ...
2
votes
6answers
311 views

SQL Server 2005: Selects good, Inserts bad

We've come across a perplexing problem with our database application. We're running the application in 3 different (but similarly spec'd) environments. Select Insert Env1 0.81ms 0.94ms ...
1
vote
1answer
562 views

GRANT PERMISSIONS ON SQL Server 2008,

I got the following issues while querying a database, and somehow I am not yet able to resolve it. 1. The SELECT permission was denied on the object So I executed the following command on SSMS ( I ...
0
votes
2answers
1k views

MySQL database really slow with a really big table [closed]

I have a MySQL table with 150 million rows. Below is its data structure. Below is some of its data. Now, using PHP My Admin I ran the below command. SELECT `iwords` FROM `wordstable` WHERE ...
-1
votes
0answers
14 views

using update query with subquery in Oracle sql [migrated]

I have an update query where I am trying to update a field but for more than one record, I am trying a join but it doesn't work. Below I get multiple values that come back from the select statement ...