Find answers to your questions about Database Administrators or help others by answering their Database Administrators questions.
I have this kind of string 12s2-3a abc def and I am trying to apply the regexp ^(?=.*d) to remove the first part and having as left abc def. I...
Asked on 12/19/2021 by Randomize
1 answerI need to apply Sliding Window Partitioning on a table that contains 1B of records.CREATE TABLE table_1( [Id] [bigint] IDENTITY(1,1) NOT NULL, [log_date]...
Asked on 12/19/2021
1 answer| family_id | parent_id_1 | parent_id_2 | -----------------------------------------------| 1234 | 9999...
Asked on 12/19/2021 by cubesnyc
2 answerI am trying to sort rows from a table in PostgreSQL 10.12:CREATE TABLE example ( id serial PRIMARY KEY, val text NOT NULL, x integer...
Asked on 12/19/2021 by Oğuz Can Sertel
2 answerI was trying to install SQL server on my Debian Linux. Installation part went well but when I tried to run setup file I am getting following error message. Is...
Asked on 12/17/2021 by LilRazi
3 answerI'm working with a team to upgrade a four node AlwaysOn Availability Group from SQL Server 2012 to 2016. Two of the nodes are local and two are in Azure....
Asked on 12/17/2021 by alcor8
1 answerI have an issue with SQL Server that is really driving me nuts so I wanted to ask if anyone has any suggestions. I have a program that does a...
Asked on 12/17/2021 by M_Lyons10
2 answerI have a table with columns with severities like:name | critical | major | trivial ----------------------------------------Apache |2 |3 ...
Asked on 12/17/2021
1 answersomething strange is happening to my database. my understanding is that the SERIAL datatype is the Postgres equivalent of MySQL's auto-increment and that omitting it from an INSERT clause will...
Asked on 12/17/2021
1 answerI will start by mentioning that I am very new to databases. I am working in MySQL. Can anyone give me a layman's view of when you would use which...
Asked on 12/17/2021
2 answerGet help from others!
Recent Answers
Recent Questions
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP