Top new questions this week:
|
|
According to the documentation the returned column timestamp_utc should be of type datetime2(7) But when I query like this SELECT * FROM sys.fn_xe_file_target_read_file(‘system_health*.xel’, null,…
|
|
I have a database (full recovery model) with multiple filegroups, that each have full and diff backups. I am able to replicate an online piecemeal restore (SQl Server 2019 Enterprise Edition) as it is …
|
|
I am struggling to find the best way to migrate some “varchar” columns to “nvarchar”. One of the options i am using is to add new nvarchar column(s) then update the values from the …
|
|
I have been using SQL Server Management Studio (SSMS) for a while now, but is there a way to switch to the right or left editor tab quickly using a keyboard shortcut? Currently, I have to use the …
|
|
I’m trying to hack a FLOSS application called Phabricator / Phorge Let’s take this simple MySQL table storing some questions by ID and their status (open, closed, invalid etc.): CREATE TABLE `…
|
|
Given the following data: create table datas (id int, data jsonb); insert into datas (id, data) values (1, ‘{“key1”: {“foo”: “bar1″,”some”:”thing1&…
|
|
I have the following ORACLE SQL table/data: A DATE_FIELD C D 1 01-JAN-13 hello 0 2 01-FEB-13 wonderful 10 3 20-MAR-13 world 20 4 21-APR-13 tree 10 5 21-JUN-13 tree 30 6 01-JUL-13 world 10 7 30-…
|
Greatest hits from previous weeks:
|
|
Is there a best practice between using a LEFT JOIN or a NOT EXISTS format? What is benefit to using one over the other? If none, which should be preferred? SELECT * FROM tableA A LEFT JOIN tableB B …
|
|
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 …
|
|
I need to remove a database from a PostgreSQL DB cluster. How can I do it even if there are active connections? I need sort of a -force flag, that will drop all connections and then the DB. How can I …
|
|
This one seems to be a common question in most forums and all over the web, it is asked here in many formats that typically sound like this: In SQL Server – What are some reasons the transaction log …
|
|
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 …
|
|
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, …
|
|
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 …
|
Can you answer these questions?
|
|
I am trying to run a couple of reconciliation queries to identify missed deletes from our change data capture tool, but I need it to run relatively fast… My source and target tables are identical …
|
|
I have a small database on a server in my LAN that I try to access remotely via ODBC. Currently, I am making a program in Visual Basic to access, retrieve and display data from the server to an Excel …
|
|
My configuration is: Compute AWS ECS cluster with a Django based API (Using ORM). 1vCPU and 4GB of memory per container. Database RDS MariaDB db.t3.medium instance (2 vCPU, 4GB of memory) gp3 type …
|
