All Questions

0
votes
1answer
40 views

SQL Server Auditing [on hold]

Situation: I am looking into getting some basic SQL auditing set up (for both compliance and security), for both Server and Database level specifications. I know that the specification groups should ...
0
votes
0answers
6 views

ODBC “generate SSPI context” error

We have a new SQL server has only TLS 1.1 & 1.2 enabled. We installed SQL server on it with "Local system" account. Later we change it to a domain account. User experience the "generate SSPI ...
0
votes
0answers
22 views

Know which table is READ / UPDATE / INSERT / DELETE

Context : I have a legacy PostgreSQL database (currently 9.5 but can be any newer version) and a tons of script / program acceding it. All this script can do various operations on the table's row (...
0
votes
0answers
18 views

How can I resolve the `package mysql-server is not installed` issue?

I have just upgraded MySQL from version 5.5.55 to version 5.6, via SSH. I have managed to successfully start the MySQL, however I am experiencing the 500 Internal Server Error when trying to access ...
0
votes
1answer
20 views

Big performance difference between two Mysql db with similar workload [on hold]

I'm puzzled by the behaviour of two Mysql db configured in the same way (I compared global variables and variables). They are use roughly by the same number of customers, or at least, I don't ...
4
votes
1answer
74 views

Huge Heap Table and table compression on SQL Server 2016

My database size is huge, and recently I noticed that a new table added few months ago is the culprit. Here is the table script. SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo]....
0
votes
0answers
24 views

Calculating Running Total in SQL

I have been looking online for an answer but do not really know how to formulate correctly what I would like to achieve and whether it's possible, sorry if the question sounds dumb. I have Site data ...
7
votes
1answer
129 views

XML Query Question

I'm trying to generate a SQL query to get the "DATE" values out of the following SQL XML: I've tried something like this but I don't think I'm understanding the concepts. select xConfig.value('(/...
0
votes
0answers
8 views

I have a *.v12 file I would like to export into an csv/excel sheet

I have this file, it took me about a day to find out that it is a *.v12 extension (initially the file was extension-less when it was handed it me). I am 100% sure it's a v12 database engine file. the ...
6
votes
1answer
64 views

How do I force SQL Server to use my spatial index through a view?

I have tables which holds transactions for properties that are stored as lat long pairs. (There are more columns and datapoints then in my example schema). A common request is to find the ...
0
votes
2answers
37 views

Get single records when duplicate records exist in 2 table

I have 2 tables. TableA is the sales and TableB is the leads table. I'm trying to see if the people in the leads TableB made a purchase and their name appears on the sales TableA. If they do I only ...
-1
votes
0answers
10 views

Exporting data using SSIS export of this data 'https://thomsonreuterswss.my.salesforce.com/7011B000002hRs2QAE' gives error of truncation [on hold]

[Flat File Destination [55]] Error: Data conversion failed. The data conversion for column "Description" returned status value 4 and status text "Text was truncated or one or more characters had no ...
0
votes
1answer
11 views

'utf-8' codec can't decode byte ERROR when querying data

I have created this foreign SQL Server using tds_fdw foreign data wrapper: CREATE SERVER servprod_sqlprod_mydb FOREIGN DATA WRAPPER tds_fdw OPTIONS (servername 'XX.XX.XX.XX', port '1501',msg_handler ...
0
votes
0answers
11 views

Mysql 8.0.16 crash due to informatiin_schema.Keywords table

How to resolve issue of mysql 8.0.16 crash?mysql 8.0.16 crash many times and shown server logs due to invalid argument.and in error log query is select WORD from information_schema.KEYWORDS. how to ...
4
votes
0answers
29 views

What DBMS to choose for my production environment? [on hold]

This is my very first question on the StackExchange/StackOverflow community. I originally am an electrical engineer so I hope you bear with me. I need to set up a database whose purpose is to be ...
0
votes
0answers
25 views

Oracle - stop dbms_service

I need to stop read-write service on standby so is there a way to lock connection within a specific service or to set a service as read-only? Thanks in advance.
1
vote
1answer
51 views

T SQL Cte Previous record calcuation

I'm using SQL Server 2016. I have the below table: SKU Shop Week ShopPrioirty Replen Open_Stk Open_Stk Calc 111 100 1 1 0 17 ...
0
votes
1answer
17 views

Split rows and assign a specific value to each group

I have a scenario where i need to split rows in a table and assign certain values to a column for each group. The table name is customers(contains around 300K rows) and i need to split the customers ...
0
votes
0answers
6 views

SSRS 2016 - Encryption Key Issue

i need help for one of SSRS 2016 issue. After every reporting service restart encryption keys are lost.. every time we have to manually restore the keys. Is anyone faced such scenario? Any help ...
0
votes
1answer
22 views

How to get my result from Procedure

How can i get my out parameters from my procedure. My stl_mbc_cdr table has over 100 records and i cant see my results. declare call_charge VARCHAR(10); MSG_OUT VARCHAR(50); BEGIN FOR ...
2
votes
0answers
51 views

Range lock on not existing record [duplicate]

We have some sort of logging table where a record gets inserted whenever a thread is working on a certain topic. It's possible that two separate threads try to start working on the same topic. ...
0
votes
0answers
8 views

Azure Storage Account access

What is the difference between SAS token and access keys (internally)? Which is the better way of accessing the storage? SAS keys do have expiration so admins do have control for how long it will ...
0
votes
0answers
14 views

Flyway Tool usage for database driven project [on hold]

In our company we are using SVN for source code check-in and regular installation Unix scripts to execute Oracle SQLs in next environments. I was looking for flyway tool for migration and I tested for ...
2
votes
1answer
31 views

How to clear the InnoDB redo log before starting mysqld for crash recovery

System: Windows Server 2012 R2, MariaDB 10.2.8 We are currently trying to recover from a quasi-crash (it was a normal shutdown, but mysqld won't start up again) and are having problems with the redo ...
1
vote
2answers
22 views

MySQL - Can we use the same temporary table name in different stored procedure?

In our database, we generate statistics by periodically calling a large number of stored procedures in the event. Considering there are two SP auto_update_daily_users auto_update_daily_orders Is ...
1
vote
3answers
32 views

SQL join multiple “id” columns from a single row to another table [on hold]

Apologies if this has been asked but I've tried searching and haven't come across anything similar. I have a two tables in a MySQL database. Athletes and Teams The athletes table contains the ...
-1
votes
1answer
18 views

i need to change all my user databases from full recovery to simple by using command in four servers

I need to change all my user databases from full recovery to simple recovery by using command in all my servers. need to create a stored procedure can you please give me a solution .. Thanks in ...
4
votes
1answer
47 views

sp_whoisactive @get_locks parameter xml error

I often receive this error when running the following command sp_whoisactive @get_locks = 1 Msg 6841, Level 16, State 1, Procedure sp_WhoIsActive, Line 4287 FOR XML could not serialize the data ...
0
votes
0answers
15 views

MariaDB filled up /tmp folder till no more disk space is left [on hold]

Could anyone here take a look at this section of MariaDB log and let me know what is causing MySQL to use up all the disk space in the /tmp partition? My guess is that it was caused by a badly ...
0
votes
2answers
43 views

Why is my SQL Server database file so large?

I have a relatively simple database that is over 300MB on disk. When I look at the table data it adds up to just over 5MB. Please see the screenshot below: This screenshot can also be seen here. ...
1
vote
1answer
22 views

Unable to downgrade MySQL from version 8 to 5.6 nor start MySQL (MySQL Error Log Included)

I run a Plesk VPS (OS: Centos 6/Linux (Final)), whereby I recently tried to upgrade the MySQL from version 5.5.55 to version 5.6. Being relatively new to this area, I strictly followed this Plesk ...
7
votes
0answers
63 views

What are the practical impacts of the sys.dm_exec_query_stats warning in the documentation?

The documentation for sys.dm_exec_query_stats states the following: An initial query of sys.dm_exec_query_stats might produce inaccurate results if there is a workload currently executing on the ...
0
votes
0answers
14 views

SQL Server tempDB data file is growing very fast. 120gb

My tempDB is now over 120GB. It has grown 65GB in a couple of hours. It is not the log but the actual DB that is growing. Reports show 99% is unused space. I tried restarting the server that SQL ...
0
votes
0answers
17 views

Append to SQL from Access is dropping leading zeros

My append query from Access to SQL is dropping leading zeros. The "Number" is stored in an Access table with the field type of Text. In Access the characters appear as an 8 character field (00012345)...
1
vote
0answers
23 views

MariaDB Spider sharding: automatic XA commit?

I'm planning to use Spider to shard my huge table across multiple backend nodes. What I'd like to do, is inserting on the Spider node(s) on the virtual big table, and Spider have it distribute it for ...
0
votes
2answers
39 views

Postgres speed up index creation for large table

I have a large Postgres table with 2+ billion entries (1.5TB) and mostly non-null, char var columns. To speed up inserts, I dropped the indexes before bulk uploading. However, it is now taking forever ...
0
votes
0answers
14 views

How to create a correct entity-relationship diagram (ERD) about a video game profits scenario

I'm starting to build my application database, and I'm really new to the this world, so I have a lot of doubts about my ERD and if its entity types and relationships are ok. This is an application ...
0
votes
0answers
22 views

TPC-H, create tables with primary/foreign keys or indices [on hold]

I'm a benchmarking noob. I need perform some benchmarking using TPC-H. I noted that the original dss.ddl script provided by the tpc website for TPC-H has no indexes or primary/foreign keys. The ...
-1
votes
2answers
24 views

index for ILIKE on postgresql, inconsistent performance

I have a table with about 64 Million rows, I have created the following index on the address_url column CREATE INDEX trgm_idx_address_link ON public.address_link USING gin (address_url ...
0
votes
0answers
55 views

Allocating Rows From One Table to Available Date Range in Second Table

I designed a Shop Floor Scheduling System and it’s been running well for years, but the managers are now asking for something more precise and what they are asking for puts me outside my comfort zone. ...
-3
votes
0answers
24 views

MySQL Replication via SSH Tunnel - Master Server ID same as Slave ID [on hold]

I followed the below link to setup replication via SSH Tunnel. But the replication doesn't work as can be seen in the output below. mysql> show slave status\G; *************************** 1. row **...
2
votes
1answer
29 views

How to pass variable to PL/pgSQL code from the command line?

I am running a psql script from the command line with variables something like: psql ...... -v now_utc=$NOW_UTC Then I want to use this in my script like: $$ DECLARE _now_date timestamp := :...
-2
votes
1answer
42 views

How can I find out who's logged on to database?

I'm trying to rename a database in SSMS and I get this error: The database could not be exclusively locked to perform the operation So how can I find out who or what is using this database? I don't ...
1
vote
2answers
35 views

Do I Alter user quota in USERS tablespace?

I'm new to Oracle so please bear with me. After installing Oracle XE 11.2, I created user SALES and granted create session and create table to the user. Once I logged in with SALES I tried to create ...
-1
votes
1answer
24 views

Sql server Cluster 2 node with failover option [on hold]

Problem statement -I have a situation, while the daily data is being loaded in the sql server DB with Insert, update DML operations, the user reports should continue viewing previous day data. Once DB ...
1
vote
2answers
108 views

How to Return Zero Values In Group Query

I have this query: SELECT fksiteID, SUM(SearchTypePerson) + SUM(SearchTypeLocker) + SUM(SearchTypeSpotRandom) + SUM(SearchTypePersVehicle) + SUM(...
7
votes
2answers
56 views

Will Postgres perform the computation of calculated columns that aren't selected in a view?

I'm trying to understand the performance impact of selecting data from a view, where one of the columns in a view is function of other data in the original table. Does the computation get performed ...
0
votes
1answer
58 views

Unable to use today's date as a criteria in a query

Ok, been a good decade since I've worked with Access and SQL, so a little forgiveness please. Short version - when I add the query criteria to only display rows which match today's date, the query ...
0
votes
0answers
43 views

Issues after changing compatibility level in sql server [closed]

We are currently in process of upgrading SQL server compatibility level from that of 2008R2 to 120 [SQL 2014]. We do not see much issues reported in performance after change. However for one of the ...
0
votes
0answers
3 views

PgBouncer user_lookup function for multiple databases

I would like to create a pgbouncer.user_lookup function (https://pgbouncer.github.io/config.html#example) and update the auth_query parameter in order to not rely on userlist.txt file. In case my ...

15 30 50 per page