Questions tagged [query]
196 questions
4
votes
1 answer
SQL Azure insert query ten times slower on V12 than V11?
I noticed performance degradation about two weeks ago impacting one of our applications with an SQL Azure backend. It's running on V12 on tier S1 90% of the time, sometimes scaling to S2, S3 or P1.
Basically i was experiencing significantly slower…
![](../../users/profiles/335065.webp)
enter.net
- 51
- 5
4
votes
1 answer
SCCM query for cluster (virtual) name
I'm trying to determine if the cluster name is stored in SCCM audit data. I see the host name in [v_R_System], and I'm able to identify cluster nodes here. What I need is the virtual name for the cluster nodes.
![](../../users/profiles/141200.webp)
Eric Higgins
- 93
- 1
- 8
4
votes
2 answers
What is the most efficient way to add a lot of data to a mysql database?
I have a batch of data that needs to be added to a mysql database every day consisting of about 100K queries.
START TRANSACTION;
INSERT IGNORE INTO info (Created, Modified, MType, Pform, Name, Version, Sig) VALUES…
![](../../users/profiles/163970.webp)
Daniel
- 43
- 4
4
votes
5 answers
Query DNS for multiple domains at once
I have recently moved servers and want to query all of the accounts domains on the new server to check that they are all resolving to the correct NS.
I am currently using http://www.whatsmydns.net/#NS which is great.
However, it's rather a slow…
![](../../users/profiles/170258.webp)
Solace
- 41
- 1
- 1
- 2
4
votes
1 answer
MySQL slow query log logging all queries
We have a MySQL 5.1.52 Percona Server 11.6 instance that suddenly started logging every single query to the slow query log. The long_query_time configuration is set to 1, yet, suddenly we're seeing every single query (e.g. just saw one that took…
![](../../users/profiles/134149.webp)
Blanka
- 145
- 1
- 5
4
votes
1 answer
How to make BIND behave differently depending on query source?
How would one make BIND behave differently depending on the source IP address? For example, I want to use different forwarding DNS servers for different people on my network.
![](../../users/profiles/131319.webp)
Richard Hum
- 185
- 1
- 7
4
votes
2 answers
Estimating MySQL Query Runtime
I ran a MySQL query from command line using the following:
nohup mysql --user=root --password=XXXXXXXXX database < report.sql > results.tab
This query is extensive (5000 lines) and running a complex search over 90,000,000 rows from 150 tables.
This…
![](../../users/profiles/137199.webp)
reefine
- 239
- 5
- 11
4
votes
3 answers
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 database.
However **I can't figure out how to load…
![](../../users/profiles/7234.webp)
James McMahon
- 763
- 2
- 8
- 16
3
votes
1 answer
Update InfluxDB measurement names
Is there a way to update existing measurement names in an InfluxDB? When my system was originally set up we used measurement names like "CheckCPU" or "CheckLOAD" and have changed to all lower case such as "checkcpu" and "checkload" which is…
![](../../users/profiles/144902.webp)
Jason P
- 33
- 1
- 6
3
votes
1 answer
Expensive LDAP queries from Workstations
Troubleshooting high LSASS process on a DC found expensive queries originating from a few workstations.
Each query is as follows:
Visited Entries: 1Million+
Returned Entries: <50 (most of the times 0)
Compared applications installed on these…
![](../../users/profiles/145496.webp)
Darktux
- 827
- 5
- 20
- 36
3
votes
3 answers
Event Log > Filter Current Log > XML > where EventData contains text
I'm trying to search through the windows event log for anything where the event data contains the string TCP Provider, error: 0 as part of a longer error message. To do this I created the code below:
…
![](../../users/profiles/137255.webp)
JohnLBevan
- 1,134
- 7
- 20
- 44
3
votes
3 answers
Can IP tables allow specific DNS queries based on domain name?
I have iptables blocking all UDP traffic at the moment, however I want to allow only certain DNS queries to get through.
Let's use google.com as an example.
I am trying to use string matching to find the domain name in the request, and allow it.…
![](../../users/profiles/151417.webp)
Jarred Kenny
- 31
- 1
- 2
3
votes
1 answer
how do I list Distribution Group (List) and their members inside of an OU using AD or exchange 2010
our entire domain has thousands of distribution groups, while i can use the script referenced here:
How to get a list of all Distribution Lists and their Members in Exchange 2007?
to pull all distribution groups and their members, it would be too…
![](../../users/profiles/146332.webp)
wraak
- 33
- 1
- 3
3
votes
2 answers
how solve Recursive Queries error in intodns web site?
Please see the below link :
intoDNS Web Site
How can I solve Recursive Queries error!
the entire error is below :
Recursive Queries I could use the nameservers listed below to
performe recursive queries. It may be that I am wrong but the…
![](../../users/profiles/68880.webp)
SilverLight
- 290
- 3
- 10
- 22
3
votes
1 answer
Active Directory lookups from bound Mac without user credentials
One of my Mac boot scripts needs to grab a property from AD that is not one of the ones I can see with the built in tool called dscl, which is pretty much limited to Users, Groups, and Computer searches. Normally I would just do a raw ldap query,…
![](../../users/profiles/83408.webp)
Geordie Korper
- 51
- 2