Top new questions this week:
|
|
Suppose I have a SQL Server Credential saved in the database with a specific secret. I want to only modify the credential if the secret saved in the database is different from the actual secret. …
|
|
I’ve got two tables in SQL SERVER 2019: Condition table with 2 FK on Reference table. Condition table has appropriate indexes on FK columns. The schema screenshot and SQL script to generate it are …
|
|
I’m a DB and SQL beginner. I’m putting together a basic PHP app that has a few SQL queries. In all my searching and learning, every example accessed the database by first logging in. Makes sense, but …
|
|
On our MySQL 8.0.23 server, when a user tries to drop a procedure created by another user they get the following error: Error Code: 1227 Access denied; you need (at least one of) the SYSTEM_USER …
|
|
I have installed SQL Server Express 2019 on my machine and after installation, I am able to login into server using the Windows Authentication method like And as you can see the sa account has been …
|
|
I have an SQL Server 2019 table that has rows for certain years: with data (year_, amount) as ( select 2024, 100 union all select 2025, 200 union all select 2025, 300 union all select 2026, 400 union …
|
|
I am looking for informations without finding them. If I create indexes in a aws aurora mysql instance, do I have to pay? The only things I found is that you pay for all I/O operations (and for …
|
Greatest hits from previous weeks:
|
|
I forgot how I started PostgreSQL the last time (it was months ago) and I don’t remember where the data directory is located. The postgres command seems to require the location of the data directory. …
|
|
I am trying to learn PostgreSQL administration and have started learning how to use the psql command line tool. When I log in with psql –username=postgres, how do I list all databases and tables? I …
|
|
I would like to benchmark some SQL-queries agains my PostgreSQL database. Is there any way I can time SQL-queries using psql?
|
|
I installed PostgreSQL because I need to restore a large .backup file I received for upload to another platform (it’s 38 million rows which was apparently too large for the person to export any other …
|
|
I created a backup of all my databases using mongodump command. Now I want to restore a specific database using mongorestore command. How is this possible, I use this command: –db option then …
|
|
Usually, if conditions are not required in our query statements, we don’t use a WHERE clause. But I’ve seen a WHERE 1 clause being used in many places, even where other conditions are not present. …
|
|
I have a table with 100 columns. When selecting data in SQL Plus the output wraps, making it difficult to read. What I’d rather like is either a horizontal scroll bar to appear or somehow send the …
|
Can you answer these questions?
|
|
I wasn’t sure where to post this question. If this is not the right place, kindly point me in the right direction. We have SQL Server 2012 and 2014 on-prem. My intention was to forward the error logs …
|
|
I need connect production_list and design table to same table. Is that right connection? How to query and calculate materials of statis material and colorful(production_list has width, length, and …
|
|
Thanks for checking my question I encountered a strange issue. the same query in same db return different actual time here is explain analyze statement explain analyze SELECT COUNT(1) AS `cnt` FROM `…
|
