Top new questions this week:
|
I’m running SQL Server 2022 RC1 setup on an AWS i3.16xlarge with 2 sockets, 2 NUMA nodes, 32 logical processors per node, 64 logical processors altogether. Setup is recommending MAXDOP 8: But if you …
|
Building statistics on a clustered columnstore table always seems to read the whole table, even if I ask for a small sample. Why is this?
|
over-extended In SQL Server Extended Events for the blocked process report and deadlock XML, it’s possible to get multiple SQL Handle values back to identify queries involved in the raised event. …
|
BACKGROUND I am using Microsoft SQL Server Management Studio v18.9.1 on Windows 10. I’ve created a database to store test results of our company’s widget (not yet being produced). I am working on a …
|
I was reading this blog post which contains a query that can allow you to find when a DROP was fired. I changed LIKE ‘DROPOBJ%’ to NOT LIKE ‘DROPOBJ%’ so I can return more rows: SELECT [Current LSN] …
|
I have a question about the performance tuning of in clause in sql query. The Postgres version is 10.18. I did two queries below. The difference of performance of those two queries are huge. For sql, …
|
Ive been trying to understand the thoughts of the person who designed this database. I want to know what this procedure is called and why its beneficial. The person who designed this is gone and I …
|
Greatest hits from previous weeks:
|
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 …
|
There are similar questions asked and answered in this network related to the error message given in the question, however this problem is a little different from each. I have installed oracle 12c in …
|
I don’t design schemas everyday, but when I do, I try to setup cascade updates/deletes correctly to make administration easier. I understand how cascades work, but I can never remember which table is …
|
If I go to mysql shell and type SELECT * FROM users I get – +——–+—————-+———————————+———-+———–+——————–+——————–+ | USERID | …
|
I am trying to learn PostgreSQL administration and have started learning how to use the psql command line tool. When I log in with psql –username=postgres, how do I list all databases and tables? I …
|
Is there any built-in function/stored procedure/query which is helpful to retrieve information about the size of MyTable in the SQL Server database?
|
I am using mongodump from mongo tools to download a backup of my server. However as I run the command, the command returns “Unrecognized field ‘snapshot'”. The full error is: Failed: error reading …
|
Can you answer these questions?
|
I am running bcp to output data to a file. I cannot run bcp out in read committed mode because of the reasons mentioned in snapshot replication – corrupted BCP files. I tried using read committed …
|
I imported into PostgreSQL a layer which I created an identifier allowing to make a join in order to recover geometries. These geometries are distributed in several layers and some geometries are …
|
I need your help to get a count of unique claims from a table where claim_id and claim_id2 can occasionally crisscross So for example, given a table with the following rows: Table scripts: create …
|