The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
2answers
57 views

MySQL stop responsing when modify main tables

It's an InnoDB database. The query cache has 1.2GB in size with 300k queries in the cache. Most of the cached queries are related to 3 major tables (260MB data length plus 600MB index length ...
1
vote
1answer
332 views

PostgreSQL - Using COALESCE keyword in SSIS

When I am trying to use the COALESCE key word in an OLE DB Source control, it always returns a negative number in the results set. I am using a Native OLE DB\PostgreSQL Native Provider as a ...
2
votes
1answer
163 views

SQL server Intergration services 2008 sub queries

I am looking for a way to execute sub queries from within a main query that I execute in my SSIS package. So When I execute the package, I want to be able to execute the sub query after everyline ...
0
votes
2answers
171 views

MySQL server has gone away occasionally on simple select query

For many weeks I have had a problem with a simple SQL query where from time to time the MySQL server has crashed. But recently it is crashing every day, 1-2 times a day. The query is very simple: ...
0
votes
1answer
354 views

MySQL 5.1 Slow SHOW DATABASES (phpMyAdmin)

We have about 200 databases and since upgrading from 4.1 to 5.1 we've noticed that PHPMyAdmin takes a while to load the left navigation sometimes. Is there anything we can do to make this quicker? ...
0
votes
2answers
935 views

SQL Server query hangs indefinitely - restoring database only solution

Occasionally we encounter a query that hangs indefinitely on our SQL Server. This query is being called from a separate ColdFusion web server. If I run profiler while it is hung I just see locks ...
1
vote
1answer
264 views

mysql slow query log

I am trying to write a script to parse the MySQL slow query log. I have seen 1 or 2 parser. does anyone know how to extract the information from that log? I mean does anyone know the structure of the ...
1
vote
1answer
2k views

Handler_read_rnd is too high (more than 2GB)

I am running an advertising program and there are some SELECT, UPDATE and DELETE queries when showing ads. Sometimes, displaying ads is fast but sometimes it is too slow. At this time, it is slow and ...
0
votes
1answer
285 views

SQL Query fields change to uppercase on upload to server

I have just finished developing an app using CodeIgniter. When I upload it to my Host (Hostgator shared) some of the SQL text is converted to uppercase and rendering the app unusable. In my database ...
1
vote
3answers
690 views

Perfectly reproducable select statement default ordering issue

I've recently been chasing an issue with a client's db... solution found, but impossible to recreate. Essentially, we're doing a Select * from mytable where ArbitraryColumn = 75 Where MyTable has ...
1
vote
3answers
380 views

“Delete query” not able to be completed

I have a very simple mysql script that is running. But it hangs, and runs forever without finishing. What are possible reasons, and how can I resolve them? delete from guid_target_infos where type_id ...
2
votes
1answer
193 views

Simple SQL Server 2005 Replication - “D-1” server used for heavy queries/reports

We have two SQL 2005 machines. One is used for production data, and the other is used for running queries/reports. Every night, the production machine dumps (backups) it's database to disk, and the ...
3
votes
1answer
153 views

Should I be suspicious of this querystring?

I noticed in my application event log some errors: Exception message: A potentially dangerous Request.QueryString value was detected from the client (term="DTİNST32") Request URL: ...
1
vote
1answer
560 views

Active directory - query groups by email address

How do I query my workplace's directory to get a list of all the groups with an associated email address that terminates in "fr"? I can use either the AD snap-in or the commandline tools, but no third ...
2
votes
2answers
591 views

A more useful MySQL Query log that's suitable for tail -f'ing

In order to debug a webapp and mysql queries, I've enabled the mysql query log. However it's not a very good format to tail and grep through. Ideally I'd like to be able to only show queries from a ...
1
vote
2answers
150 views

select values must match the number of insert columns

I have the following query... ive checked and rechecked the types and number of values in both the insert into and the select statements. I can't figure out what is wrong. insert into ...
0
votes
1answer
71 views

How to use variables in inner queries?

I am trying to build a query that has something like this select id, (select top 1 create_date from table2 where table1id = t1.id and status = 'success') ...
0
votes
1answer
67 views

Querying Exchange 2003 for Information About Attachments

I'm looking into the possibility of switching from Microsoft Office to Google Apps. Although Google Apps are not currently as feature rich as the Microsoft Product, the Google tools provide greater ...
0
votes
2answers
53 views

Show any null value?

is there a SQL statement that would show any null value in any record? For example if I had a table Alpha with Column A, B, and C where C was null in one record, and B was null in another, and A in ...
0
votes
5answers
1k views

What is faster for reading: SQL CE or file on the disk?

On my server side I need to store user data somehow. Some time ago I used to use INI files for writing and reading those values. Even with tousands of files it was incredibly fast (ms), maybe due to ...
12
votes
3answers
5k views

How do I remove a specific bad plan from the SQL Server query cache?

We have one particular SQL Server 2008 query (not a stored proc, but the same SQL string -- executes every 5 minutes) that intermittently caches a very bad query plan. This query normally runs in a ...
0
votes
1answer
392 views

Access or SQL query to list most recent AutoNumber within a specific Range

I am looking to write a query where it shows me the last 50 of the highest ids, without knowing the most recent id #. The id is an autogenerated primary key. Any help would be appreciated. Maybe I ...
0
votes
3answers
3k views

The database at work is Unidata, which is unfamiliar to me. Is there a free 3rd party app I could use to query the database?

I know just enough about databasing to get by - it's not normally within the scope of my job, but I think it's good for everyone to know a little bit. I'm trying to access some of the data in our DB ...
0
votes
1answer
283 views

What's a typical turn-around / response-time for this query/reply scenario?

I'm doing a feasibility study on a proposed wireless/wired network topology for a coming project of ours. A rough description of its use is "like an industrial sensor system". It looks something like ...
0
votes
1answer
524 views

What is star query optimization?

I found in a features table for SQL Server 2005 a row named "Star query optimization" but it is not explained anywhere. Could this be a feature that optimizes a query like : SELECT * FROM Table
0
votes
3answers
5k views

AD query to see what PCs a user has logged onto recently

Is there any way to run a query in AD to check what PCs a user has logged into recently. regards Mike
0
votes
1answer
996 views

Restrict “Authority Section” on BIND

I just switched from Microsoft DNS to BIND 9.3 for a DNS acting as a Caching Nameserver. Previously when I used "dig" to perform a lookup...I just got the "QUESTION" & "ANSWER SECTION" with ...
2
votes
1answer
109 views

pl/sql Oracle syntax

I have a query in pl/sql that i need to migrate to ms sql. select count(*) from table1 t1 where (conditions1) and (conditions2) and variable = t1.column1(+) Could anyone tell me what the (+) after ...
1
vote
3answers
204 views

Can you make MS Sql Server reject all queries matching a certain pattern?

I would like to know if you can make Sql Server look at incoming query strings and reject ones that match a certain pattern. In other words, for a certain class of queries (perhaps identified by a ...
0
votes
4answers
1k views

Slow INFORMATION_SCHEMA query

We have a .NET Windows application that runs the following query on login to get some information about the database: SELECT t.TABLE_NAME, ISNULL(pk_ccu.COLUMN_NAME,'') PK, ...
17
votes
18answers
21k views

Are there any good and lightweight LDAP querying tools? [closed]

As developers we sometimes need querying LDAP. Do you know useful tools for this task? edit: I don't mean in code, I mean utility/tool (command-line or gui, mostly gui) for just to look/confirm data, ...
4
votes
3answers
5k views

Importing a large SQL script into SQL Server?

I'm trying to move a database from our production server to our test server. I've used Microsoft's Database Publishing Wizard to create a script containing the schema and data for the production ...
10
votes
9answers
46k views

Command line active directory query email address for username

On Windows XP in an Active directory environment - what is the easiest way for me to query a user's email address from AD given their username on the command line. (Assuming I know where it is kept ...