Questions tagged [sql]
Structured Query Language (SQL) is a declarative query language for relational databases. Consider also using the tag for the specific database software if your question involves vendor extensions or language quirks.
575
questions
0
votes
0
answers
6
views
Is SQL or SQL-Lite suitable for use on my laptop to look at a database of 10 million records? [closed]
I have a real estate data file in an .rpt format that i am told i can access and search with SQL.
I am very familiar with EXCEL, but this would be my first time using SQL, and seeking guidance as to ...
1
vote
0
answers
42
views
sqlcmd how to find current port number on server
I'm trying to find TCP port which sql server uses to test one Jira connector, did my homework but that tcp: option doesn't work trying everything. In my example 1432 is actual port I got from DBAs
...
0
votes
0
answers
31
views
Azure SQL Server - Is ApplicationIntent=ReadOnly always honored?
I am using Azure SQL database instance (Business Critical, Read Scale-out enabled) and I would like to offload some of the traffic to Read-Only replicas.
Does adding ApplicationIntent=ReadOnly to ...
0
votes
0
answers
71
views
I can't start the MSSQLSERVER on new esxi host
I am a student currently studying virtualization and SQL. After obtaining approval from my instructor, I attempted to transfer a virtual machine (VM) to my personal laptop.
However, upon doing so, I ...
0
votes
0
answers
18
views
Retrieving specific text data from all files present in a folder
I've some SQL queries (DBT) in a folder. I've to run the dbt sql files and validate them. Before running, I've to clone the sources used in the queries. I'm going through each file and making note of ...
1
vote
1
answer
66
views
MySQL: Converting Row to Columns Based on Field Values
I am using MySQL Workbench 8.0.
I will break my question into two parts as I believe the first part will be straightforward (but is slightly beyond my current SQL knowledge level) but the second part ...
11
votes
2
answers
2k
views
How to find which senders use the most space in my Gmail account?
How could I sort email senders (distinct "from" addresses) by the total amount of space each sender's cumulative messages (including bodies and attachments) are occupying in my Gmail account?...
2
votes
1
answer
181
views
Could interrupting a SQL query that was taking too long lead to a decrease in disk space?
For a personal data analysis project, I was trying to find the most frequent 3 products that were being sold together by doing a self join (twice).
As the query was taking over 15 mins and the laptop ...
0
votes
0
answers
83
views
Power Query SQL bring in cell contents for the where statement
I am trying to build a flexible sql where statement so that my power query can pull the exact data the user specifies. I have an excel worksheet with about 18 cells that the user populates. I use ...
3
votes
1
answer
8k
views
How to solve The following signatures couldn't be verified because the public key is not available: NO_PUBKEY EB3E94ADBE1229CF
I am trying to install SQL server on Linux using Ubuntu from this link: https://learn.microsoft.com/en-us/sql/linux/quickstart-install-connect-ubuntu?view=sql-server-ver16&tabs=ubuntu2204
And, in ...
0
votes
1
answer
10
views
How to replay recent Influx queries
I want to load test Influx, how do I replay the recent queries that were executed? I have not found anything meaningful on Google.
-1
votes
1
answer
414
views
Attuinity connectors SSIS package migrate to SSIS 2022
I have 2015 SSIS solution with attuinity oracle connectors, I am unable to open the package in VS 2022 since it does not support attuinity any more, I get Object reference not set to instance of the ...
1
vote
0
answers
44
views
Is SQL a good way to optimise data access to just one huge table?
TLDR; Is SQL the way to go when trying to access one huge data table?
As title. In astronomy we often must deal with huge data files. Usually, we can manage to do it using different optimisation ...
0
votes
0
answers
38
views
SQL Server Connection to Excel Workbook
Upon re-opening my excel workbook, the SQL Server connection and associated queries are not saved and unable to be refreshed. How do I resolve this issue? I am accessing the DB via a remote connection ...
-1
votes
1
answer
3k
views
How to resolve SQL error 772
Using the preloaded ODBC driver version 10.00.22621.1992 on Windows 11 and added the data source in System DSN. When it tries to test the connection I get this error (picture below).
SqlState:01000
...