Questions tagged [query]
The query tag has no summary.
198 questions
Score of 1
2 answers
263 views
Why does a SQL Server stored procedure generate different execution plans depending on the parameter value?
I am testing query execution plan behavior in Microsoft SQL Server 2022 Developer Edition and SSMS 20.2.1
Table:
CREATE TABLE Orders
(
OrderID INT,
CustomerID INT,
OrderAmount INT
);
...
- reputation score 195
Score of 1
0 answers
453 views
cannot find either column dbo or the user-defined function or aggregate"dbo.F_GET_CAMBIO, or the name is ambiguous
I recovered my database when I try to run a sale report on the software I get this error message" cannot find either column dbo or the user-defined function or aggregate"dbo.F_GET_CAMBIO, or ...
- reputation score 11
Score of 1
0 answers
657 views
Initial patch install checking via SCCM query
I want to make a better query for Windows Server OS patching (2016 & 2019). The one listed below is what I wrote that my company currently uses. If a newly built servers OS install time is ...
- reputation score 111
Score of 1
0 answers
137 views
Which is the correct capability in Courier SMTP config to get user's password (encryption type)
MySql: 8.0.34-0ubuntu0.22.04.1
I have followed this guide: Postfix With Courier IMAP Mail Server Installation (unfortunately they do not answer questions).
I had to change the encryption method for ...
- reputation score 111
Score of 0
1 answer
1693 views
AWS CLI : How to use "--query" to get output from nested JSON
I am using aws-cli v2 to get the --query output from AWS Describe-volumes. In this, I am trying to get the volume id, size, Instance ID, state. Instance ID is nested in the AWS Describe-volumes.
...
- reputation score 3
Score of 1
0 answers
152 views
Reduce Query Syntax for ends_with()
I have the following query:
--query "Contents[?ends_with(Key, 'jpg') || ends_with(Key, 'NEF') || ends_with(Key, 'nef') || ends_with(Key, 'CR2') || ends_with(Key, 'cr2')]"
Is there a way to ...
- reputation score 111
Score of 1
2 answers
550 views
Nginx rewrite to specific part of requested uri
I am quite new to nginx rewrite concept and I can't figure out how to rewrite the requested_uri to a specific Uri. I am trying to make rewrites to specific js files.
For example, I have this ...
- reputation score 11
Score of 0
1 answer
390 views
GCP- Alert for adding new user or service account to a project
I want to create an alert in my project in GCP that lets me know when a new user or service account is added to the project. I understand I need to use Logs Explorer and run a query but I am not sure ...
google-cloud-platform
- reputation score 1
Score of 2
1 answer
2172 views
json_query help - not producing expected output
I am trying to build an array to use for with_nested, but I cannot get past why json_query isn't outputting the actual hosts assigned to each cluster:
Play:
- name: Index clusters.json
shell: cat {{ ...
- reputation score 149
Score of 1
0 answers
370 views
SCCM collection evaluates major version numbers in unexpected way
Why do SCCM collections based upon the logic Installed Applications (64).Version is less than "100.0" not evaluate to true for applications of version 99.* and below?
The full WQL query ...
- reputation score 11
Score of 1
1 answer
2027 views
AWS Athena Query 2 separate tables together
I have 2 Tables, and i need to query them together, for example.
From the first table i get results with my query:
InstanceID, title, status and etc...
From the second one:
key, value, region and etc.....
- reputation score 141
Score of 0
1 answer
914 views
Why my simple searching query is too slow?
I don't know why searching in my "cities" table is so slow.
My query looking for a table "cities" located about 25km from the city.
I use this simple query and the database takes ...
- reputation score 13
Score of 0
1 answer
965 views
SQL Developer queries are very slow if I am not connected as sys
I want to run my PL/SQL Queries on SQL Developer and created a new user connection. But if I run:
set serveroutput on size unlimited;
begin
dbms_output.put_line('Hello Oracle.');
end;
/
clear ...
- reputation score 1
Score of 1
0 answers
1159 views
Alternate method for caching mysql query (query_cache) on version above 8.0
On mysql version 8+ the query_cache support was removed.
I know why it is not a friendly thing with InnoDB when considering the CPU.
But I've some databases which really need this support where user ...
- reputation score 33
Score of 3
2 answers
1597 views
MySQL - Select queries 10x slower on Azure VM vs on-prem VM
We have been working on a project to migrate a MySQL database from an on-premise Linux server to a Windows VM on Azure (IaaS). (There's a specific reason because of which we have gone with the IaaS ...
- reputation score 31