Find answers to your questions about Database Administrators or help others by answering their Database Administrators questions.
We have a team of people, we all log in MSSQL Server from SSMS using our Active Directory accounts, by Windows Authentication. Our AD accounts are added to an AD...
Asked on 12/31/2021
2 answerThe following query is returning a SEQ Scan instead a Index.select file_name from myschemadb.my_files where file_name = 'djsaidjasdjoasdjoaidad'Engine Postgres 11.5 My table:CREATE TABLE myschemadb.my_files id...
Asked on 12/31/2021 by Daniel1791
1 answerLets assume there is a design where every table is represented by a view, that is simply selecting all of the columns of the table and all the rows.--vwSelect...
Asked on 12/31/2021 by user2417731
1 answerHi I stuck in strange issue with one of my query. Formula : (28800/3600-(28382.6/3600-(1920/3600+1860/3600))) = So, Input Equation: = (28800/3600-(28382.6/3600-(1920/3600+1860/3600))) = (28800/3600-(28382.6/3600-(0.53333333333333+1860/3600))) = (28800/3600-(28382.6/3600-(0.53333333333333+0.51666666666667))) = (28800/3600-(28382.6/3600-(1.05))) = (28800/3600-(28382.6/3600-1.05)) = (28800/3600-(7.8840555555556-1.05))...
Asked on 12/31/2021 by humberto herrara
1 answerI create a table named person which columns such as name, sex, occupation and so on.I want to give each user select grant over that user’s own tuple only....
Asked on 12/28/2021 by Ju Ju
2 answerWe have a server that's disconnected from the world. It's a high end system with 48GB memory and 500GB SSD hard disk, 16 core CPUs. We're trying to do a...
Asked on 12/28/2021 by Khom Nazid
2 answerI am looking for the most efficient way to reference multiple tables in one table, when there is only one reference possible at a time. Which means tables A and...
Asked on 12/28/2021 by Guiik
1 answerLet's say I have one table defined as thisCREATE TABLE sales ( agent_id integer references agents(agent_id), sale_date date, ...
Asked on 12/28/2021 by Edgar Ramírez Mondragón
2 answerI have Mysql 5.5 server on a EC2 instance which have multiple sql users to perform operation , now i want to create a back up db server .For which...
Asked on 12/28/2021
0 answerI have a table containing an array, and I want to check if it is empty or NULL. It appears that I cannot check the NULL directly! Can anyone shed...
Asked on 12/28/2021 by PhilHibbs
1 answerGet help from others!
Recent Answers
Recent Questions
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP