Questions tagged [query]
The query tag has no summary.
198 questions
1
vote
2
answers
164
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
);
...
- 189
1
vote
0
answers
420
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 ...
1
vote
0
answers
622
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 ...
- 111
1
vote
0
answers
132
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 ...
- 111
0
votes
1
answer
2k
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.
...
1
vote
0
answers
148
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 ...
- 111
1
vote
2
answers
544
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 ...
- 11
0
votes
1
answer
381
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
2
votes
1
answer
2k
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 {{ ...
- 149
1
vote
0
answers
357
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 ...
- 11
1
vote
1
answer
2k
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.....
- 141
0
votes
1
answer
909
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 ...
- 13
0
votes
1
answer
959
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 ...
1
vote
0
answers
1k
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 ...
- 33
3
votes
2
answers
2k
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 ...
