User CaM

1 vote

Accepted

Is there a way to track changes on two tables using SQL?

answered Oct 27, 2021 at 16:07

1 vote

Secure way of providing MySQL password in a batch file

answered Jun 25, 2021 at 13:03

0 votes

Accepted

Linked Server throws metadata error

answered Jan 21, 2021 at 14:45

1 vote

Single table or multiple tables for optional keys

answered Jul 9, 2019 at 18:45

0 votes

Options for structuring multiple associations to a record

answered Jul 8, 2019 at 20:10

2 votes

Accepted

Maintaining data integrity when one table has multiple relationships, but only one should be used. (is this bad design?)

answered Apr 8, 2019 at 13:47

1 vote

Accepted

Splitting a year into pieces

answered Feb 14, 2019 at 17:22

1 vote

Accepted

Added a new listener to my 'listeners.ora' file. How can I connect directly to it with SQLPlus? (skipping tnsnames.ora for now)

answered Feb 14, 2019 at 15:26

2 votes

Accepted

Setting up a many-to-many relationship based off of two other many-to-many relationships

answered Feb 14, 2019 at 15:02

2 votes

Accepted

Will a VM backup of a SQL Server work for restoring the SQL database

answered Feb 14, 2019 at 14:43

0 votes

AG listener creation failed SQL Server

answered Dec 4, 2018 at 18:45

0 votes

Tracking Unintended Row Changes

answered Sep 27, 2018 at 20:40

1 vote

How to find cores and logical processors in SQL Server

answered Aug 29, 2018 at 20:19

0 votes

concatenating multiple column with separator

answered Jun 22, 2018 at 18:27

1 vote

Accepted

RMAN validate incremental level 1 backups?

answered Jun 20, 2018 at 19:06

4 votes

Accepted

Why shouldn't user-defined database roles be members of fixed roles?

answered Jun 13, 2018 at 19:44

1 vote

What's the best way to deal with a database with a big table with information that will RARELY be used?

answered Jun 11, 2018 at 16:53

0 votes

How to transfer data from denormalized table to normalized tables in Oracle?

answered May 30, 2018 at 18:52

4 votes

The Service Broker endpoint is in disabled or stopped state - AoAG - SQL Server 2012 - 15 minute interval

answered Apr 9, 2018 at 15:03

1 vote

Restoring a database

answered Mar 16, 2018 at 13:14

0 votes

How to access a fresh install of SQL Server 2012?

answered Nov 13, 2017 at 19:07

6 votes

Does taking transaction log backups every 15 minutes consume more disk space than log backups every 6 hours?

answered Nov 13, 2017 at 16:06

3 votes

Accepted

Unable to connect to pluggable database in Oracle 12c

answered Nov 8, 2017 at 20:35

4 votes

Accepted

Error Message Saying "Invalid Object Name"

answered Nov 8, 2017 at 20:26

2 votes

Unable to connect to Oracle 11g server remotely using SQL developer ORA-12520

answered Sep 15, 2017 at 14:33

12 votes

Accepted

varchar(MAX) text cuts off while going more than 8000 characters inside a procedure

answered Aug 25, 2017 at 19:05

0 votes

Update trigger fired before insert trigger upon insert of new row

answered Aug 25, 2017 at 13:08

0 votes

How can I model a medical scenario in an entity-relationship diagram?

answered Aug 9, 2017 at 20:36

5 votes

Modelling a database structure for multiple user types and their contact information

answered Aug 9, 2017 at 18:53

4 votes

limiting db user password to 3 days

answered Aug 7, 2017 at 12:53

Stack Exchange Network

74 Answers

Is there a way to track changes on two tables using SQL?

Secure way of providing MySQL password in a batch file

Linked Server throws metadata error

Single table or multiple tables for optional keys

Options for structuring multiple associations to a record

Maintaining data integrity when one table has multiple relationships, but only one should be used. (is this bad design?)

Splitting a year into pieces

Added a new listener to my 'listeners.ora' file. How can I connect directly to it with SQLPlus? (skipping tnsnames.ora for now)

Setting up a many-to-many relationship based off of two other many-to-many relationships

Will a VM backup of a SQL Server work for restoring the SQL database

AG listener creation failed SQL Server

Tracking Unintended Row Changes

How to find cores and logical processors in SQL Server

concatenating multiple column with separator

RMAN validate incremental level 1 backups?

Why shouldn't user-defined database roles be members of fixed roles?

What's the best way to deal with a database with a big table with information that will RARELY be used?

How to transfer data from denormalized table to normalized tables in Oracle?

The Service Broker endpoint is in disabled or stopped state - AoAG - SQL Server 2012 - 15 minute interval

Restoring a database

How to access a fresh install of SQL Server 2012?

Does taking transaction log backups every 15 minutes consume more disk space than log backups every 6 hours?

Unable to connect to pluggable database in Oracle 12c

Error Message Saying "Invalid Object Name"

Unable to connect to Oracle 11g server remotely using SQL developer ORA-12520

varchar(MAX) text cuts off while going more than 8000 characters inside a procedure

Update trigger fired before insert trigger upon insert of new row

How can I model a medical scenario in an entity-relationship diagram?

Modelling a database structure for multiple user types and their contact information

limiting db user password to 3 days