Newest Questions
105,219 questions
-1
votes
1
answer
38
views
Columns With No Statistics Warning, though the statistics exists
I have a SQL Server query which has suddenly started picking a "bad" plan.
I can see a warning on a clustered index seek saying there are columns with no statistics
However, I can see that ...
- 2,252
0
votes
0
answers
10
views
MariaDB replication issue between versions 10.6.19 (master) and 10.11.10 (slave)
I’m running into a replication problem between two MariaDB servers:
Master: MariaDB 10.6.19
Slave: MariaDB 10.11.10
Replication appears to start correctly. SHOW SLAVE STATUS\G under the slave shows ...
- 1
0
votes
1
answer
23
views
Database backup exclude list
I have 100s of SQL instances and there are cases where some databases are excluded from backup in the ola backup job. I am doing an backup audit and want to retrieve the excluded database list in the ...
- 1
0
votes
1
answer
21
views
Database Mail, parse error when adding query with @query
I have the task of getting the free space in the database each month, and emailing the results using Database mail.
Database Mail is setup and working.
I have a query (copied from Greg Robidoux) that ...
3
votes
1
answer
126
views
SQL Server Log File (ldf) size difference between servers
I've recently been involved with a project to migrate a customer's SQL Server environment to a new server. Since the migration, the .ldf file for a particular database on the new server is growing ...
- 131
3
votes
2
answers
81
views
STRING_SPLIT - issue with NCHAR(769) and SQL_Latin1_General_CP1_CI_AS
In database
on SQL Server 2022 Standard Edition (CU19)
with default collation SQL_Latin1_General_CP1_CI_AS
I am splitting CHAR(31) separated values using STRING_SPLIT. I have an issue when the ...
- 4,378
0
votes
0
answers
9
views
Can I grant read-only access to MongoDB database without creating a user or enabling authentication?
My Questions:
Is it possible to share read-only access to my MongoDB database WITHOUT creating a user? Is it possible to grant read-only permissions WITHOUT authentication being enabled on the server? ...
- 1
0
votes
1
answer
16
views
postgres - locate user/role on filesystem level
postgres database objects are represented as files, or directories on the filesystem level (inside $PGDATA/base/).
I can see that i.e. for database, table.
What is the presentation of a postgres role/...
- 293
0
votes
0
answers
56
views
Unexplained MYSQL memory allocation
I’m running MySQL server on Linux.
I have a long-standing issue on my database server — it keeps consuming an excessive amount of memory for no clear reason. As a result, I was forced to periodically ...
1
vote
0
answers
6
views
Does GridDB perform partition pruning on a TIMESTAMP row-key when predicates are direct ranges?
I have a time-series container in GridDB keyed by a TIMESTAMP row-key. Simple range predicates on the row-key are fast, but when I rewrite the same logic using functions (for example, truncating/...
0
votes
1
answer
42
views
How to fix “Access denied for user 'root'@'localhost'” in MySQL?
I'm trying to connect to my local MySQL database from PHP.
But I always get this error:
Access denied for user 'root'@'localhost' (using password: YES)
Here is my connection code:
<?php
$servername ...
0
votes
1
answer
15
views
xampp - phpmyadmin non stop loading
At the start, when I deal with my project, it has no problem at all. But after I insert a database it has problems, my phpmyadmin keeps loading non-stop.
I've tried to uninstall and reinstall, it can ...
0
votes
0
answers
27
views
Replication vs new database to stock user custom object
I have server1\database1 (production) being replicated to server2\database1 (reporting) running on SQL Server 2016. In both databases, there are objects (table, sp, function, ...) created by the user. ...
- 11
1
vote
0
answers
12
views
What is data affinity and how it is related to partitioning internally?
Data affinity is mentioned in SQL Reference Documentation
Option related to data affinity can be specified in the format "WITH
(property key = property value, ...)"
with a link to Feature ...
- 11
0
votes
1
answer
63
views
Strange CheckDB Results
I think I have a failing disk sub-system on a Proxmox VM running Microsoft SQL Server 2019 (RTM-CU32-GDR) (KB5065222) - 15.0.4445.1 (X64) Standard Edition (64-bit) on Windows Server 2022 Standard 10.0 ...
- 430