Top new questions this week:
|
|
SQL Server 2016 added the AT TIME ZONE operator. From the documentation: AT TIME ZONE implementation relies on a Windows mechanism to convert datetime values across time zones. AT TIME ZONE calls …
|
|
I’m currently querying the sys.dm_db_log_info() DMV to retrieve the VLFs from a database to determine when I can shrink, reorganise and reduce the amount of fragmented (10 MB VLFs) in the TLOG file. …
|
|
This question is a follow-up to somebody else’s question: Adding an INNER JOIN ruins query performance due to different execution plan despite updated STATISTICS and RECOMPILE, why? My question is …
|
|
When I want to using this sql to check using index or not: explain SELECT id AS id, sub_source_id AS sub_source_id FROM article WHERE sub_source_id IN ( select sub_source_id from sub_relation …
|
|
My Postgres version is 11.15. I have a table like: id employee 1 Anna 2 Bill 3 Carol 4 Dave 5 Tom The output I need is id cumulative_employees 1 Anna 2 Bill, Anna 3 Carol, Bill, Anna 4 …
|
|
i am working with a database that is already in production, that means the table can not be changed. I need to filter data by date and time, nevertheless the date and time values are not stored as a …
|
|
I have SQL Server 2000 (aka version 8.0) that failed to recover a database after a power failure. The only backup I found are the current mdf file and an ldf file that is two years old. Can I restore …
|
Greatest hits from previous weeks:
|
|
How can I dump a specific table or set of tables without including the rest of the db tables?
|
|
I’m new to MySQL and I would like to know: How can I create a database with charset utf-8 like I did in navicat? create mydatabase; …seems to be using some kind of default charset.
|
|
This seems to be an area with quite a few myths and conflicting views. So what is the difference between a table variable and a local temporary table in SQL Server?
|
|
When I try to use \i on a file that is not in the psql.exe folder it says C:: permission denied. For example I have a file with SQL command at C:\Users\Work\Desktop\School Work\load_database.sql and …
|
|
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. …
|
|
When using PostgreSQL v9.1, how do I list all of the schemas using SQL? I was expecting something along the lines of: SELECT something FROM pg_blah;
|
|
I am importing a 7 GB foobar.sql to restore a table in a local database. $ mysql -h localhost -u root ‘my_data’ < foobar.sql $ mysql –version /usr/local/mysql/bin/mysql Ver 14.12 Distrib 5.0….
|
Can you answer these questions?
|
|
I’m currently working on a BASH script to build a new Aurora cluster based on the latest snapshot of an existing cluster, then set up MySQL replication from the old one to the new. In the past I’ve …
|
|
I downloaded Firebird 2.5 from the official website and installed on a Linux machine. The install location is /opt/firebird. I want to be able to view authentication attempt logs for security reasons (…
|
|
I’m designing a postgres table to record the intervals contained in a weekly schedule. It would hold schedules for multiple businesses, and a simple example dataset might look like: business_id …
|
