User CaM

13 votes

Drives vs. Mount Points?

answered Feb 14, 2017 at 17:56

11 votes

Accepted

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

answered Aug 25, 2017 at 19:05

10 votes

Is SELECT * ok in a Trigger. Or am I asking for trouble?

answered Feb 1, 2017 at 15:06

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

5 votes

Accepted

Oracle 11g Rman restore with another database name from backup in windows platform

answered Jul 17, 2017 at 18:07

5 votes

Accepted

Is a partial restore of data from backup possible?

answered Aug 7, 2017 at 12:44

5 votes

What is Oracle equivalent for Linked Server and can you join with SQL Server?

answered Feb 2, 2017 at 21:09

5 votes

What can be the downside of always having a single integer column as primary key?

answered Feb 3, 2017 at 20:15

4 votes

Accepted

Why I am seeing NULL value in a table where the schema defines as NOT NULL field?

answered Feb 10, 2017 at 19:13

4 votes

Invalid object name after aliasing a table?

answered Feb 10, 2017 at 21:46

4 votes

Storing NULL versus storing '' in a varchar column

answered Feb 17, 2017 at 15:10

4 votes

limiting db user password to 3 days

answered Aug 7, 2017 at 12:53

4 votes

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

answered Aug 9, 2017 at 18:53

4 votes

SQL Server End to End Encryption Options

answered Aug 4, 2017 at 13:07

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

4 votes

Accepted

Error Message Saying "Invalid Object Name"

answered Nov 8, 2017 at 20:26

4 votes

Accepted

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

answered Jun 13, 2018 at 19:44

3 votes

Accepted

Unable to connect to pluggable database in Oracle 12c

answered Nov 8, 2017 at 20:35

3 votes

Accepted

Why would someone store text in an SQL Image field?

answered Jul 10, 2017 at 15:11

3 votes

How to insert big blob data in Oracle?

answered Mar 17, 2017 at 12:14

3 votes

Syntax error, MySQL alter column

answered Feb 7, 2017 at 16:56

2 votes

Change file types from rows data to log

answered Feb 8, 2017 at 20:55

2 votes

Accepted

Why does this trigger slow down updates so much

answered Feb 1, 2017 at 20:54

2 votes

Instant File Initialization

answered Feb 1, 2017 at 13:21

2 votes

Accepted

How should I model a database structure to store word information on flashcards?

answered Feb 1, 2017 at 13:43

2 votes

Accepted

Is it possible to write out images from SQL Server to a mapped drive?

answered Mar 17, 2017 at 15:12

2 votes

Is taking backups pointless after a specifc size is reached?

answered Feb 17, 2017 at 19:24

2 votes

Accepted

Is it okay to define a foreign key referencing a ‘user_id’ column from every table?

answered Feb 13, 2017 at 21:36

2 votes

Accepted

Seeing commands run by user in SQL

answered Feb 9, 2017 at 18:57

2 votes

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

answered Sep 15, 2017 at 14:33

Stack Exchange Network

75 Answers

Drives vs. Mount Points?

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

Is SELECT * ok in a Trigger. Or am I asking for trouble?

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

Oracle 11g Rman restore with another database name from backup in windows platform

Is a partial restore of data from backup possible?

What is Oracle equivalent for Linked Server and can you join with SQL Server?

What can be the downside of always having a single integer column as primary key?

Why I am seeing NULL value in a table where the schema defines as NOT NULL field?

Invalid object name after aliasing a table?

Storing NULL versus storing '' in a varchar column

limiting db user password to 3 days

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

SQL Server End to End Encryption Options

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

Error Message Saying "Invalid Object Name"

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

Unable to connect to pluggable database in Oracle 12c

Why would someone store text in an SQL Image field?

How to insert big blob data in Oracle?

Syntax error, MySQL alter column

Change file types from rows data to log

Why does this trigger slow down updates so much

Instant File Initialization

How should I model a database structure to store word information on flashcards?

Is it possible to write out images from SQL Server to a mapped drive?

Is taking backups pointless after a specifc size is reached?

Is it okay to define a foreign key referencing a ‘user_id’ column from every table?

Seeing commands run by user in SQL

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