Database Administrators Stack Exchange Community Digest

Top new questions this week:

Updating rows in Azure SQL Server causing unexpected page splits

I'm getting a lot of page splits in a live environment using Azure SQL Server PAAS that I don't understand. The update that's occurring should not increase the size of the row and therefore never ...

azure-sql-database page-splits accelerated-database-recovery  
asked by Andrew Marshall 7 votes
answered by Andrew Marshall 5 votes

Improper use of logical operators has led to poor query performance

I have a table with huge amount of data (Nearly 15 million) and below structure. create table test (a int,--> /* There is a normal index on this column */ b int, <other columns>) There is a ...

sql-server query-performance t-sql sql-server-2016 query  
asked by Pantea 7 votes
answered by Andriy M 24 votes

Index with IGNORE_DUP_KEY = ON filters out non-duplicate records

Below is a script which can be used to re-produce the issue I am facing. Basically the question is this: why is it that the record with (ID1 = 6, ID2 = 7) is not populated into the final #tt2 table? ...

sql-server t-sql unique-constraint  
asked by SQL_Guy 5 votes
answered by Michael Green 7 votes

Are TOAST rows written for UPDATEs not changing the TOASTable column?

Imagine I have a table in Postgres 13 like this: CREATE TABLE public.people ( id integer PRIMARY KEY, full_name character varying(255), bio text ); I then insert a row with enough ...

postgresql update storage  
asked by James Healy 5 votes
answered by Erwin Brandstetter 7 votes

How to reverse only English words?

I've an nvarchar column with English and Hebrew letters in some fields. In the fields where the English and Hebrew are together, the English letters are in reverse order (this is how the ERP program ...

sql-server sql-server-2012 t-sql sql-server-2016 collation  
asked by Avi 3 votes
answered by Jorge Bugal -2 votes

How to get historical queries in SQL Server, based on time

Please how do I get the query that was running at a specific time in SQL Server 2016? Something similar to AWR report in Oracle? We need to know what was happening at a specific time in the past ...

sql-server query-performance sql-server-2016 audit  
asked by PTL_SQL 3 votes
answered by Grant Fritchey 3 votes

Why are there no "Daylight Time" time zones in SQL Server?

I am converting the times of some datetimeoffset columns from UTC to Eastern. I am doing this via the command UPDATE MyTable SET MyColumn = MyColumn AT TIME ZONE 'Eastern Standard Time' This seemed ...

sql-server timezone  
asked by Jer 3 votes
answered by AMtwo 9 votes

Greatest hits from previous weeks:

How to grant super privilege to the user?

I have created a user and given privileges to the user1. `grant all privileges on db1.* to user1@'%' with grant option; Am using mysql workbench to import dumps to my database. While importing dumps ...

mysql mysql-workbench  
asked by delete my account 57 votes
answered by RolandoMySQLDBA 44 votes

ALTER TABLE - Rename a column

This is driving me nuts! I want to rename a column from read-more to read_more in my blog table I tried all this: ALTER TABLE blog RENAME COLUMN read-more to read_more; ALTER TABLE blog CHANGE ...

mysql mysql-5.5 mysql-5  
asked by Bojan 109 votes
answered by Ulrich Thomas Gabor 147 votes

When should a primary key be declared non-clustered?

While creating a test database for another question I asked earlier, I remembered about a Primary Key being able to be declared NONCLUSTERED When would you use a NONCLUSTERED primary key as opposed ...

sql-server primary-key  
asked by Stuart Blackler 190 votes

Difference between Sharding And Replication on MongoDB

I am just confused about how Sharding and Replication work. According to the definitions I found in the documentation: Replication: A replica set in MongoDB is a group of mongod processes that ...

mongodb  
asked by Saad Saadi 114 votes
answered by Philipp 160 votes

"ORA-03113: end-of-file on communication channel" on startup

I have been reading posts here, on Oracle support, and anywhere else I can find for the last three days and I've given up on this problem... An Oracle database hung. Shutdown of the database sat for ...

oracle startup  
asked by kainaw 28 votes
answered by kainaw 44 votes

How can I move a database from one server to another?

How can I move MySQL tables from one physical server to another? Such as this exact scenario: I have a MySQL server that uses innodb table and is about 20GB size. I want to move it to a new server, ...

mysql backup migration mysqldump  
asked by John 155 votes
answered by David Hall 95 votes

Select multiple values in LIKE Operator

I have a SQL query given below, I want to select multiple value using like operator. Is my Query correct? SELECT top 1 employee_id, employee_ident, utc_dt, rx_dt FROM employee INNER JOIN ...

sql-server sql-server-2008 like operator  
asked by l.lijith 16 votes
answered by Andriy M 22 votes

Can you answer these questions?

Postgres 13 Sort Performance

Sort performance on one of our query is very bad that it takes up to 14 seconds to run the query. Here is the Query: SELECT "stock_quant".id FROM "stock_quant" WHERE ((((("...

postgresql postgresql-performance postgresql-13  
asked by Abul Hassan 1 vote
answered by dwhitemv 0 votes

PostgreSQL tds_fdw Column Truncated to 2048 Characters

I set up several tds_fdw foreign tables on a Postgres 13 server accessing a MSSQL 2014 server. Everything has worked just fine, until I had a need to select from a table with a large column (nvarchar(...

sql-server postgresql  
asked by blazonstone 1 vote

SQL AAG Cluster - Diagnosing Partner Quorum Failure

Recently we had a failure of our SQL Server (2016) Always On Availability Group, where our fileshare witness node was briefly inaccessible to our two nodes due to a CPU spike. We have two SQL server ...

sql-server availability-groups high-availability  
asked by 4oo4 1 vote
You're receiving this message because you subscribed to the Database Administrators community digest.
Unsubscribe from this community digest       Edit email settings       Leave feedback       Privacy
Stack Overflow

Stack Overflow, 110 William Street, 28th floor, New York, NY 10038

<3