Top new questions this week:
|
|
I have a large partitioned table that stores monetary transactions between accounts. CREATE TABLE “transactions” ( “from” BYTEA NOT NULL — sender account ,”to&…
|
|
I’m trying to prove that extended events (hence audits as well) are logged in UTC time zone and can’t be changed but I can’t find an official source. I’ve searched Microsoft’s pages and SQL Server …
|
|
I recently dealt with a problematic stored proc. At times, runs beautifully fast, other times, runs very very long. I determined that bad parameter sniffing was the cause. Just for info – The …
|
|
We want to enforce that a combination of an entity is unique in a join table. Suppose we have the following many to many relationship between widgets and combinations widgets ——- widget_id w1 …
|
|
First let me start by saying that I’ve done intensive research before asking here. I have a table datatable that looks like this: +—-+——+—–+—–+—–+—–+—–+—–+—–+—–+—–+—-…
|
|
I have a table like this: Id Name Value Date 1 John 1 12/01/2022 2 Jane 2 12/01/2022 3 John 3 12/02/2022 4 Max 4 11/30/2022 Assuming that today is 12/02/2022, I want only Jane in the result …
|
|
While understanding the logical replication process, one thing is still not clear to me. When the decoding process will start? What is my understanding is, Lets say i have a publication and a slot. …
|
Greatest hits from previous weeks:
|
|
I used pg_restore to load my postgres db with a dump file. I connected to my db with my user : sudo -u arajguru psql dump select current_user; current_user ————– arajguru Now I was able …
|
|
I have created a table testtable inside the database testbase that have the following structure: product_no (int, not null) product_name (varchar(30), not null) price (money, null) expire_date (date, …
|
|
I have two tables in MySQL database- parent, child. I’m trying to add foreign key references to my child table based on the parent table. Is there any significant difference between ON UPDATE CASCADE …
|
|
The Debug button is present on this version of SSMS: But it is not present on version 18, preview 4: I have tried in several ways to add the Debug button to my SSMS but not successful. Is there a …
|
|
I’m sure this has been asked before but I can’t seem to find the relevant details for the following. Is there some sort of pre-built table that can do the following (I have used dba_tab_privs but it …
|
|
How to list all constraints (Primary key, check, unique mutual exclusive, ..) of a table in PostgreSQL?
|
|
I have moved my database from an SQL 2005 to a server with SQL 2008. I am now trying to create an ODBC Data Source. I am using “With SQL Server authentication using a login ID and password …
|
Can you answer these questions?
|
|
We are using CDC to feed our application. However sometimes, out of the blue, the following error occurs: Violation of PRIMARY KEY constraint ‘lsn_time_mapping_clustered_idx’. Cannot insert duplicate …
|
|
2 concurrent do not start transactions. Concurrent A locks 1-3-5 sequentially, of course, the actual locking process must be one by one.Concurrent B locks 5-8-1 sequentially, of course, the actual …
|
|
For testing, I’ve set up a XAMPP portable 8.1.12 with 10.4.27-MariaDB and enabled the FederatedX engine using this trick. When I now set up a SERVER that is not existing and a federated table that is &…
|
