Unanswered Questions
18,490 questions with no upvoted or accepted answers
25
votes
0
answers
1k
views
Splitting Snapshot files with MaxBCPThreads for Transactional Replication
I've just set up a publication, and I'm attempting to get the snapshot to apply faster. So far the Distribution Agent is respecting the MaxBCPThreads settings, but the Snapshot Agent is not. I'm ...
CommunityBot
- 1
16
votes
1
answer
471
views
Does SQL Server 2019 have task scheduling differences between enterprise and standard editions?
In How It Works: SQL Server 2012 Database Engine Task Scheduling, Bob Dorr explains some of the changes for worker scheduler assignment in SQL Server 2012. He mentions that some of the improvements ...
CommunityBot
- 1
15
votes
1
answer
457
views
Constant Scan applying
This question is a continuation of optimizer behavior exploration in regards to VALUES construct started here and here. I want to ask about VALUES and APPLY this time.
Using CROSS APPLY to alias an ...
CommunityBot
- 1
13
votes
3
answers
313
views
How to limit memory consumption of mysql server to prevent OOM kills?
My MySQL instance is getting killed by the Linux oom_killer due to huge consumption of memory by mysql when inserting into longblob columns. This occurs when restoring a mysqldump which contains a ...
CommunityBot
- 1
13
votes
0
answers
3k
views
Best practices for keeping protobuf spec in sync with relational database (e.g. PostgreSQL)
1. We have a schema definition in Google's Protocol Buffers format that we use to generate code for different gRPC implementations (Python, PHP)
2. We have a database (PostreSQL) that is initialized ...
- 1
13
votes
1
answer
1k
views
HADR high worker thread usage
Why would an availability group's number of worker threads in an HADR pool increase well beyond minimum usage of "typically, there are 3–10 shared threads" per replica?
In one case we've observed ...
CommunityBot
- 1
12
votes
0
answers
4k
views
PostgreSQL trigram GIST vs. GIN indexes
I have a PostgreSQL 9.1 database that contains 10M+ rows and some text fields that need similarity and %word%-like searches, so I decided to use trigram indexes.
Initially, I started to use GIN ...
- 771
11
votes
1
answer
15k
views
Conceptual data model for a billing system
I am working on an existing MySQL database. My task is to create a new data model for a billing system on that existing application.
I have created a conceptual data model (click to enlarge):
##...
CommunityBot
- 1
11
votes
1
answer
781
views
MySQL deadlock: upsert query acquiring gap lock twice?
I am trying to debug a deadlock scenario which has been puzzling me for quite some time now. I am wondering if someone can shed any light into how this can happen.
Here is the deadlock output:
------...
CommunityBot
- 1
10
votes
0
answers
307
views
dm_os_memory_cache_clock_hands understanding
As I mentioned in this question I'm trying to understand the working of clock hands. Simply put clock hands move when there is memory pressure so that cache entries can be removed or the cost can be ...
- 1,960
9
votes
1
answer
7k
views
DBeaver launch script from file
I'm trying to find a good alternative to SQL Developer for performing queries and scripts on Oracle instances.
I find DBeaver to be an interesting tool, it has a lot of great features, BUT it seems ...
CommunityBot
- 1
9
votes
1
answer
1k
views
Convert query in words to relational algebra
I have a follow-up question to a question I have previously asked on SO.
Instead of the query from my initial question, I want to convert the following into relational algebra:
List the names and ...
CommunityBot
- 1
9
votes
1
answer
749
views
SSMS 2014 (and 2012) CTRL+TAB requires pressing enter
Sometime last week my CTRL+TAB behavior changed. I used to hit CTRL+TAB, release, then I would be in my previous document tab. Now I hit CTRL+TAB, release, and the nav window is still open requiring ...
- 101
8
votes
0
answers
150
views
Why does the cast from double precision to numeric round to 15 significant digits?
The cast from double precision (float8) to numeric rounds to 15 significant decimal digits, thereby losing information. Clearly, more precision is possible. The cast to bigint (for values within its ...
- 150k
8
votes
0
answers
3k
views
Working on a decision tree database design
I'm doing the conceptual model for a Decision tree database. The goal is store any Decision tree.
I have four entity types: DecisionTree, Node, Branch and Leaf.
Each Decision tree is composed of ...
- 22.8k