Top new questions this week:
|
|
I made this query : ALTER TABLE dbname.tablename DROP COLUMN columnname and it’s been running for a few hours and I wanted to know how much time would it still be going. There are approximatively 750m …
|
|
I tried to have this as detailed as possible. Sorry about the length! Background I created the following partitioned table protein_snp_assoc on a PostgreSQL (version 12.13) database: CREATE TABLE …
|
|
I have two simple queries: SELECT TOP(20) * FROM Clients ORDER BY City SELECT TOP(20) Id, Name, City FROM Clients ORDER BY City In the first case I get a result like this Id Name City many more …
|
|
Because of an outdated SQL Server version I have to use server-side traces to collect some information, but if I try to implement it I get the error Filters with the same event column ID must be …
|
|
I was exchanging with another developer regarding the performance of SELECT queries on a simple key/value table. CREATE TABLE cache ( id BIGINT unsigned not null auto_increment, …
|
|
I have the following tables from which I am to select the second highest salary: Table 1: id salary 1 100 2 200 3 300 Table 2: id salary 1 100 I wrote two SQL queries to achieve this: Query 1: …
|
|
My SQL Server admin and I are currently struggling with a strange issue. When I connect to the database from the same machine I cannot access a view definition, there is a message: Property …
|
Greatest hits from previous weeks:
|
|
I am running Ubuntu 16. I have installed Postgresql. Postgresql used to work, but then I rebooted. nmap commands show port 5432 is open. Postgres seems to be working correctly: service …
|
|
In Postgres 9.x, for a column of type UUID, how do I specify a UUID to be generated automatically as a default value for any row insert?
|
|
I’m having trouble finding answers with various Internet and Google searches for MySQL Workbench issue I’m experiencing. I have not found any answers on how to make this work again. Here’s the MySQL …
|
|
Someone was running a query on our SQL Server database remotely and their system crashed. They have no backup of that query and want to see what was run on the server. Is it possible to find this …
|
|
I installed PostgreSQL 10.1 under a CentOS 7.3 environment. The service is started (postmaster.pid file present under /var/lib/pgsql/10/data), but I need to reload configuration or restart the server …
|
|
For our application we have a configuration file for connecting to the Oracle database (URL, username, password). The application takes 2-5 minutes to start. If there is something wrong with …
|
|
I use PostgreSQL 9.1 on Ubuntu 12.04. I need to select records inside a range of time: my table time_limits has two timestamp fields and one integer property. There are additional columns in my …
|
Can you answer these questions?
|
|
Problem I try to optimize an extract/load query on a highly normalized table structure. Extract/load is implementing incremental loading using a datetime column to determine only records which have …
|
|
So I have my Table that looks some thing like Name timestamp abc 2022-03-08 06:15:11 bcd 2022-03-08 08:15:11 cvd 2022-04-10 06:15:11 Now each Name is unique in this table and it has a timestamp …
|
|
select distinct day from t1 order by 1 desc limit 1,1 should return the second latest date in t1, but this error is thrown: ParseException: mismatched input ‘,’ expecting {, ‘;’}
|
