The tag has no usage guidance.

learn more… | top users | synonyms

2
votes
1answer
18k views

SCCM 2007 Query for installed software versions

How can I write a query to find machines which installed office 2003 with Sp3 in SCCM 2007? Thanks,
1
vote
2answers
304 views

Mysql crashes by some strange queries

I have some strange log entries in my debug where I see that the mysql crashes: Apr 13 08:51:16 cronjob1 mysqld[22953]: Attempting backtrace. You can use the following information to find out Apr 13 ...
0
votes
1answer
430 views

MySQL database server on a VPS: can it handle the spike in traffic I'm anticipating?

I have VPS service with Hostican.com. 2.7GHz CPU, 2GB RAM (level 5, if you look at the site). I have a smartphone app that makes requests to PHP forms, which query the MySQL DB. I'm anticipating a ...
0
votes
1answer
73 views

dns hierarchy not returning ip address

(DNS1 ,WWW1, Gateway1) (sub-internal network) (DNS0,WWW0,Gateway0) (internal network) DNS1: 192.168.250.3/24 WWW1: 192.168.250.4/24 Gateway1: 192.168.250.1 /24 (internal) :: 192.168.0.150 ...
0
votes
1answer
145 views

MySQL's Query Optimizer's take on disk access time

I don't have a ton of background with MySQL, and I was wondering of anyone can give me some insight into MySQL's query optimizer and the impact on the cost of disk accesses in determining a query plan ...
0
votes
1answer
202 views

optimize mysql queries perfomance and speed

i need some help in some mysql queries i'm trying to improve it's performance and speed i'm trying to figure out how to do that using mysql syntax . here is an snippet of a query function i use ...
0
votes
1answer
316 views

Simple MySQL query locking up until database restart

I have a very simple query that runs in 216ms on my development machine but was taking more than 45 seconds on my production server, that is, until I restarted MySQL there: UPDATE `forum_categories` ...
0
votes
1answer
294 views

A Most Puzzling MySQL Problem: Queries Sporadically Slow

This is the most puzzling MySQL problem that I've encountered in my career as an administrator. Can anyone with MySQL mastery help me a bit on this?: Right now, I run an application that queries my ...
0
votes
1answer
224 views

CPU/ memory utilization

WE have a job running very slowly. And I required to produce the analysis of CPU/ memory utilization during that backup.Also need statustics around the database performance for that batch job. How to ...
0
votes
1answer
451 views

MS SQL Query Sum of subquery

I need a help i getting following output from the query . SELECT ARG_CONSUMER, cast(ARG_TOTALAMT as float)/100 AS 'Total', (SELECT SUM(cast(DAMT as float))/100 FROM DEBT WHERE DDATE ...
0
votes
1answer
133 views

How to search MySQL table for duplicates

In MySQL, I have a table named "city" with "city_name" and "latitude" and "longitude" in it. It appears that I have a few duplicates. What query can I run (in phpmyadmin) that will search through the ...
0
votes
1answer
309 views

MS SQL Query Count & Sum

select count(distinct consumerno), sum (case when ccon like '%D%' then 1 else 0 end) as Domestic, sum (case when ccon like '%B%' then 1 else 0 end) as Business from consumer left join contract on ...
0
votes
2answers
2k views

How to rewrite query strings in url (\img?src=foo.jpg) into cachable urls (\img-foo.jpg)?

a question that is now partially resolved. A genius who can speak Apache fluently can shine light into this matter... GIVEN: Most proxies, do not cache resources with a "?" in their URL even if a ...
5
votes
4answers
14k views

Why are my MongoDB queries really, really slow?

I've inherited a large MongoDB server at work, and have been tasked with figuring out why queries run against it are so slow. The DB contains tons and tons of records (on the order of 10^9) and takes ...
0
votes
2answers
1k views

How do I filter the Security Log using XML for the following data

A manager has asked me to log the start and stop times and dates when a user launches a particular program (Starcraft II). I have enabled logging on the user's machine so that it will report all ...
1
vote
2answers
532 views

Cancel query in MySql

I have a query running for some hours, if I cancel this query what is going to happen to the database? The query is an ALTER TABLE that adds a new column. UPDATE: I executed the script this way ...
0
votes
2answers
176 views

Is there a way to find out the detailed statistics of the querys that processed by Mysql?

The load average of my service is high, always around 15. And the reason for that is the Mysql is overloaded. I'm wondering How Can I find out which specific query/script consume the most Mysql ...
0
votes
1answer
479 views

Putting indexes in separate filegroup kills our queries

Can anyone shed some light on this? On our dev boxes, our database resides entirely in the PRIMARY filegroup, and everything works fine. On one of our production servers, recently upgraded from 2005 ...
1
vote
4answers
567 views

why this statement in oracle perform much slower then ms sql

I tried to run a simple test to see how the speed fair between oracle and Ms Sql as follow: populate two tables with 2 million records, cross join them, filter by a range, and do a sum. Both table ...
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
351 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
173 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
176 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
375 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
1k 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
281 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 ...
2
votes
1answer
3k 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
337 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
747 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
634 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
195 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
167 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
801 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
610 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
152 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
69 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
2k 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 ...
16
votes
3answers
13k 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
401 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
4k views

The database at work has Unidata format, how do I access it?

I know just enough about database 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
326 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
552 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
7k 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
1k 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
113 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
266 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
2k 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
32k 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, ...