All Questions

Filter by
Sorted by
Tagged with
0
votes
0answers
3 views

What are the real life uses of role based authentication control in a database?

I am new to database management. I was going through the mongodb docs for Role Based Authentication Control. I have understood how it works, but I have a few questions. How is it applied in real life ...
-1
votes
0answers
5 views

Store procedure Incorrect syntax else

Could i be missing a condition inside my store procedure? Incorrect syntax near keyword else line 41. use eNtsaRegistrationDB; create proc[dbo].[SpocCompanyRegistrationInsertUpdateSingleItem] ( @...
0
votes
0answers
4 views

MySQL replication - intermittently report ~4600 sec behind

I have a master/slave (MySQL 5.5.62) setup, with 1 master and 2 slaves, where someting strange occurs intermittently (but quite often) - normally, the slaves reports 0 seconds behind, then suddenly it ...
0
votes
1answer
11 views

first row and last row fields value from where data changed

Assume I have a table like this: I'm trying the have a outpout like following picture
2
votes
2answers
12 views

Error creating memory optimized filegroup in SSDT

I am attempting to add a memory optimized filegroup to a SQL server database project in SSDT. This is for SQL Server 2017, using Visual Studio 2017. However compiling the project (pressing F5 to ...
-1
votes
0answers
20 views

Incorrect syntax near end

Does anyone knows how to solve this issue 'Incorrect syntax near end'. Here is my store procedure. use eNtsaRegistrationDB; CREATE proc [dbo].[Usp_CheckUserRoles] @UserId int as begin if((select ...
-1
votes
0answers
6 views

I ran MySQLTuner and wondered if anyone would go over the results with me

The mysqltuner report: >> MySQLTuner 1.7.19 - Major Hayden <major@mhtx.net> >> Bug reports, feature requests, and downloads at http://mysqltuner.com/ >> Run with '--help'...
0
votes
0answers
13 views

Reseeding a identity column automatically

I have a table which has a identity column and it reached its upper limit which is an integer datatype. now i want to reseed it automatically before insert in sql
-2
votes
0answers
10 views

Splitting string into columns through loop in MySQL stored procedure

I have a table table_1 and i want to copy data of this table dynamically to other tables along with columns i.e 'table_2.column_1, table_3.column_2, table4.column_3') by passing as string. I want to ...
0
votes
1answer
11 views

Error during sp_refreshsqlmodule after altering table type

I am trying to add a column to a user-defined table type. I have done some research and here is what I have now: -- First, rename existing table type to something else EXEC sp_rename '...
0
votes
0answers
4 views

We need to do encryption in transit in mongodb so which one is recommended ssl or tsl ? and what is the difference between ssl and tls?

We are using MongoDB 4.0 community version with 1 primary 2 secondary replicaset, we need to do encryption in transit so which one is recommended ssl or tsl ? and what is the difference between ssl ...
0
votes
1answer
12 views

Firebird isql exclusive mode?

I have a vague recollection that Firebird's isql utility will in some situations make an exclusive connection to the database, meaning that any other connection attempts will be refused. I fail to ...
0
votes
0answers
6 views

Is it time to move to nosql when table A is almost table B?

The data in my backend has changed a LOT since I built it when I knew almost nothing back in 2010. I still no almost nothing, except that it might be NoSQL time. My data (ie: tables) is 283 ...
0
votes
0answers
12 views

Latest record query

I have table: CI_PREM_CHAR, please refer "Sample Table Records" sheet Actually I have tried few approaches but it is not working: Refer "My Working" sheet I am looking for the output to be as in "...
0
votes
0answers
5 views

How to handle spoon err: Permission Denied in Redis

I'm new to Redis and I'm facing this error on Windows 10 Pro (64 bit) when trying to do the background save of Redis: [14932] 18 Jan 10:57:24 # Failed saving the DB: Permission denied [14932] 18 Jan ...
0
votes
0answers
7 views

StoredProcedure has error on Field name, ID and TableName how to fix?

create proc [dbo].[Usp_UserNamebyUserID] @UserId varchar(200) as begin select UserName from Users where Id =@UserId end go Hi Mates i have this procedure on my sql editor, on the table itself from ...
0
votes
1answer
6 views

MySQL database getting connected with any username and password [duplicate]

We have a website running on an custom Ubuntu server managed and hosted by the client himself, since last two days the website database is getting hacked and someone deletes all the db tables from the ...
1
vote
1answer
23 views

What is the `TABLE example` syntax called?

In PostgreSQL, I've been using syntax like TABLE example1 UNION ALL TABLE example2 which I understand to be equivalent to SELECT * FROM example1 UNION ALL SELECT * FROM example2 But a colleague ...
0
votes
1answer
12 views

Prevent overlapping TSRANGE

I have the following PG (12) reservations table id uuid reservable_id uuid reserved_between tsrange How can I ensure there are no 2 reservations for the same reservable_id ...
-2
votes
0answers
17 views

Drop down table

i am new in database, im trying to create a simple db for social network like twitter, i have different tables like user, tweet, comment... My question : is it possible to use a table as a drop down ...
0
votes
2answers
18 views

How to completely restrict a postgres role to a single schema

I'd like to create a readonly role for a third party to access a handful of tables from the public schema without being able to view the rest of the tables in public. My initial idea was to create a ...
5
votes
1answer
316 views

Is it generally faster to select into a temp table than selecting into an actual table?

I thought I once read somewhere that writing to tempdb is faster than an actual table not in tempdb. Is this true in any capacity? I thought I recall it saying something special about tempdb and ...
2
votes
2answers
58 views

How to return ids with specific values in another column

I have a table USER_ROLE with the format like this. +--------+---------+ |USER_ID | ROLE | +--------+---------+ |1 | ADD | +--------+---------+ |1 | DELETE | +--------+---------+ |...
0
votes
0answers
11 views

What is Direct page mapping in dbms?

Can someone discuss how Direct page mapping works in dbms in details ?
2
votes
2answers
28 views

Virtualized SQL Server hits 100% CPU and 0 Active Memory

We recently experienced an odd crash with one of our server. We know what caused it, but we don't know why SQL Server responded the way it did. SQL Server 2016 Here is what happened: Friday: ...
0
votes
0answers
17 views

Do I need Adobe Acrobat DC to use Save as PDF?

I recently upgraded my company to FileMaker 18 advanced server. Many staff are accessing their databases in VMWare, some directly by vpn-ing into the company network via a laptop. We have been getting ...
0
votes
1answer
23 views

What standard SQL isolation levels do the SQLite isolation levels correspond to?

There are four standard SQL isolation levels: Read Uncommitted, Read Committed, Repeated Read, and Serializable. (c.f. Database System Concepts 6ed.) In SQLite, there are three isolation levels: ...
0
votes
0answers
7 views

Mongorestore not restoring full collection and not returning an error

I know this topic is old, but I think I am having a similar problem. I have been searching from a solution all over Stackoverflow I am running a mongodump followed by a mongorestore and in 2 out of ...
1
vote
1answer
58 views

Bigint and SQL Server performance

I inherited a database in which many of the tables have bigint as a datatype for many of the fields, and when you see the content it does not requiere all the space that bigint offers. Does using ...
1
vote
1answer
22 views

In Oracle 12c, is there an alternative to CREATE TYPE when I only have read-only privileges?

I have read-only access to a Oracle 12c system where there is zero chance I can get additional privileges or get the DBAs to change anything on my behalf (such as do CREATE TYPEs for me). I'm using ...
1
vote
1answer
39 views

How to denote separate records as “one and the same”?

Let's say there are two separate Person records V. Baker Vincent Baker each with their own various associations. These could be things like photos, contact information, etc. And let's say that it ...
0
votes
1answer
9 views

MySql replication Failure

I have a mysql (Ver 14.14 Distrib 5.7.29, for Linux (x86_64)) primary -> secondary replication setup. Initially the replication was working successfully until we had to restart the primary database. ...
1
vote
1answer
43 views

Casting int YYYYMMDD to date produces incorrect value in Squirrel-SQL

I have extracted some data from a legacy database where dates are stored as Numeric(8) values, in YYYYMMDD format. I've stored them in a staging table in that same format, and now I would like to ...
-1
votes
0answers
14 views

MySQL Table is Huge Where Only Text Values Are Stored

I am using LAMP Stack...And one of my db table wp_options (Rows: 10,600) is now about 194+ GB in size... Not sure why the size growing so much huge... As far as i am concern most of the records are ...
0
votes
1answer
20 views

Sentry One Plan Explorer History Tab

While I'm working on index tuning I would love the history bar to populate with each run so I can see the differences, I'm probably using the tool incorrectly. My current workflow is: Create New Plan ...
0
votes
0answers
19 views

PostgreSQL database cluster

I installed PosgreSQL 12 using the certified installer by EnterpriseDB. I went through the docs. In Chapter 18.2. Creating a Database Cluster, it is said that you need to initialize a database ...
1
vote
1answer
18 views

How can I see the plan for ONE statement in a stored procedure?

I've got some SQL which I've run several times a day in development, generally getting execution time of 3-8 minutes. Now I've wrapped it in a stored procedure (with no parameters), the performance ...
3
votes
1answer
26 views

SSRS Query Timeout settings: rsreportserver.config verses RDL Query.Timeout

I'm trying to understand the interaction between the SSRS DatabaseQueryTimeout (set at the server level, defaults to 120 - does this only apply to connections to the ReportServer internal database?) ...
0
votes
1answer
17 views

How often is Postgres parsing a foreign table based on file_fdw?

I have a foreign table defined with file_fdw, which reads the data from a CSV file. Postgresql parses the CSV file and converts the date for example from YYYYMMDD to YYYY-MM-DD. This works fine. My ...
1
vote
1answer
21 views

Database design for application with multiple useres

We have a task to design a software using entity frame core and a Central SQL DB. The software will have multiple users with RBAC(Role Based Access Control). DB design shall implement user group table ...
0
votes
1answer
30 views

Does CREATE TABLE AS lock the table?

In Postgres, does this query lock films for reads and/or writes? CREATE TABLE films2 AS TABLE films;
2
votes
1answer
25 views

Simple select query hangs

I have a simple query: SELECT a.name AS a_name, b.description AS b_description FROM a JOIN b ON a.id = b.a_id WHERE b.table_name IS NULL; (Names changed to protect the innocent) ...
3
votes
0answers
61 views

Change tracking causing latch contention

I am using Microsoft SQL Server 2016 (SP2-GDR) (KB4505220) - 13.0.5101.9 (X64) Jun 15 2019 23:15:58 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows Server 2012 R2 ...
1
vote
1answer
38 views

PL/SQL Script Line with Only a Dot…What is the purpose/function of the dot?

I have inherited a pl/sql script from a previous dba that worked at my company. It is used to "clean up" failed distributed transactions. The script is easy enough to understand, except for one line ...
0
votes
1answer
34 views

Piecemeal restore only one filegroup without primary filegroup restore

I have a db in SIMPLE recovery model, and regularly take FULL,DIFF backups. This db also have filegroups for each month. Each filegroup has exactly one NDF file. Like this: FileGroup: PRIMARY File: ...
0
votes
1answer
12 views

Upgrade all MySQL columns, tables, and databases from utf8mb3 to utf8mb4

I have thousands of columns across hundreds of tables in about a hundred databases inside a MySQL instance that need to be upgraded from utf8mb3 to utf8mb4. Is there a way to generate ALTER ...
0
votes
1answer
38 views

SQL Server White Papers vs Books Online - What's the difference and where are the white papers?

I've heard people reference white papers. After doing a preliminary search for SQL-Server white papers, there are various sites with random pdfs. I'm looking or white papers that will help me gain a ...
0
votes
1answer
26 views

How to Grant A User Under A Sql Domain Account To Insert and Update Records

I have a sql domain account in sql server like DOMAIN\GroupName. There are many user accounts under that account like DOMAIN\user.name. I want to give insert and update permission only to a user under ...
1
vote
0answers
13 views

How to select specific databases in a backup retention policy maintenance plan cleanup task?

I have full backups of three different databases. Right now all of their backups follow the same retention policy, but I need to setup the retention to a different amount of time for each database. ...
0
votes
0answers
20 views

Adding a column and new foreign key constraint in one line

Let's say we have a table called Salesman with the folling properties Create Table SalesMan( EmplyeeId int Primary Key, Name varchar(20) Not Null, LastName Varchar(20) Not Null, Email Varchar(...

15 30 50 per page