User Just a learner

53 votes

4 answers

290k views

What's the easiest way to create a temp table in SQL Server that can hold the result of a stored procedure?

asked Feb 13, 2012 at 8:10

23 votes

4 answers

177k views

MySQL error: Access denied for user 'a'@'localhost' (using password: YES)

mysql authentication

asked Jan 18, 2012 at 6:43

13 votes

1 answer

2k views

Is this an error in SQL Server's documentation for ROLLBACK?

sql-server transaction rollback documentation

asked Apr 11, 2021 at 8:54

11 votes

1 answer

25k views

What's the differences between the two version of oracle client download file, "client" and "client home"?

oracle connectivity client

asked Jul 29, 2019 at 17:22

10 votes

2 answers

9k views

What's the difference between a v$ view and its dba_ equivalent?

oracle view metadata

asked Jul 19, 2011 at 18:53

7 votes

3 answers

4k views

For Oracle, we mount the instance to the database or mount the database to the instance?

oracle instance

asked Jul 5, 2011 at 6:33

7 votes

3 answers

18k views

Can anyone explain to me the concept "incarnation" in Oracle database in an easy-to-understand way?

oracle backup

asked Dec 7, 2011 at 13:04

6 votes

1 answer

9k views

Are "Always On Failover Cluster Instances" and "SQL Server Failover Clustering" the same thing?

sql-server availability-groups clustering hadr

asked Apr 20, 2017 at 0:43

6 votes

3 answers

375 views

Are there any tables that I can get all Oracle supported system privileges and object privileges?

oracle permissions role

asked Aug 29, 2011 at 8:13

6 votes

2 answers

20k views

Set up a MySQL slave using mysqldump to get the initial data

mysql replication innodb mysqldump myisam

asked Dec 5, 2011 at 9:11

5 votes

1 answer

9k views

What's the differences between utf8_general_ci and utf8_unicode_ci and utf8_binary collation in MySQL?

mysql collation character-set

asked Nov 17, 2011 at 2:14

5 votes

1 answer

6k views

What's the difference between quiesce the instance and enable restricted session?

oracle

asked Oct 25, 2011 at 13:24

5 votes

1 answer

4k views

Understanding of SQL Server active/active cluster

sql-server clustering failover

asked Jun 9, 2016 at 2:38

5 votes

2 answers

604 views

What happens when you change a heap into a clustered table in SQL Server?

sql-server clustered-index heap

asked Apr 12, 2021 at 1:54

4 votes

2 answers

3k views

Question on Oracle rowid column in every table

oracle

asked Dec 28, 2011 at 17:07

3 votes

3 answers

1k views

What does "thread" mean in "thread checkpoints" context?

oracle checkpoint

asked Dec 19, 2011 at 13:58

3 votes

2 answers

8k views

How to specify the system database location when installing SQL Server?

sql-server installation

asked Jun 17, 2012 at 6:17

3 votes

1 answer

4k views

In the domain of SQL Server backup, what is a backup set, backup device, backup media, backup media set, backup media family

sql-server backup

asked Jan 21, 2013 at 13:32

3 votes

1 answer

3k views

Oracle permission issue

oracle permissions

asked Oct 25, 2011 at 18:47

3 votes

1 answer

66 views

MySQL Download Question

mysql

asked Oct 26, 2011 at 7:43

3 votes

3 answers

534 views

Same tables with same data, different SQL Server stored procedure performance

sql-server performance stored-procedures

asked Sep 29, 2011 at 10:45

3 votes

2 answers

5k views

How to set addtime(current_timestamp, '15:00:00') as MySQL timestamp column default value?

mysql timestamp default-value

asked Sep 2, 2011 at 7:17

3 votes

1 answer

366 views

Does 'LGWR' writes to online redo log files strictly in circular fashion?

oracle

asked Sep 19, 2011 at 3:14

3 votes

2 answers

640 views

How to understand "NULL NOT IN" when the set is empty?

sql-server oracle null

asked Jul 30, 2019 at 18:25

2 votes

1 answer

70 views

Can I restore my SQL Server database to a point before the last full backup with my current backup strategy?

sql-server backup transaction-log

asked Apr 18, 2021 at 16:27

2 votes

2 answers

118 views

In SQL Server, what's the impact of a checkpoint to log records in log buffer?

sql-server transaction-log log buffer-pool checkpoint

asked Apr 19, 2021 at 16:38

2 votes

1 answer

1k views

If archiving is disabled and the last redo log file is full, why LGWR continues by overwriting the first available active file, not inactive file?

oracle logs

asked Sep 19, 2011 at 3:21

2 votes

3 answers

2k views

Question about 'user process' in the context of Oracle

oracle documentation process

asked Jul 6, 2011 at 16:21

2 votes

2 answers

871 views

Can I store half of a record on one page and half of the record on another page?

sql-server sql-server-2008 sql-server-2005

asked Apr 12, 2012 at 17:35

2 votes

3 answers

2k views

SQL Server restore sequence from multiple full, diff and log backups

sql-server restore

asked Feb 6, 2012 at 1:41

Stack Exchange Network

current community

your communities

more stack exchange communities

51 Questions

What's the easiest way to create a temp table in SQL Server that can hold the result of a stored procedure?

MySQL error: Access denied for user 'a'@'localhost' (using password: YES)

Is this an error in SQL Server's documentation for ROLLBACK?

What's the differences between the two version of oracle client download file, "client" and "client home"?

What's the difference between a v$ view and its dba_ equivalent?

For Oracle, we mount the instance to the database or mount the database to the instance?

Can anyone explain to me the concept "incarnation" in Oracle database in an easy-to-understand way?

Are "Always On Failover Cluster Instances" and "SQL Server Failover Clustering" the same thing?

Are there any tables that I can get all Oracle supported system privileges and object privileges?

Set up a MySQL slave using mysqldump to get the initial data

What's the differences between utf8_general_ci and utf8_unicode_ci and utf8_binary collation in MySQL?

What's the difference between quiesce the instance and enable restricted session?

Understanding of SQL Server active/active cluster

What happens when you change a heap into a clustered table in SQL Server?

Question on Oracle rowid column in every table

What does "thread" mean in "thread checkpoints" context?

How to specify the system database location when installing SQL Server?

In the domain of SQL Server backup, what is a backup set, backup device, backup media, backup media set, backup media family

Oracle permission issue

MySQL Download Question

Same tables with same data, different SQL Server stored procedure performance

How to set addtime(current_timestamp, '15:00:00') as MySQL timestamp column default value?

Does 'LGWR' writes to online redo log files strictly in circular fashion?

How to understand "NULL NOT IN" when the set is empty?

Can I restore my SQL Server database to a point before the last full backup with my current backup strategy?

In SQL Server, what's the impact of a checkpoint to log records in log buffer?

If archiving is disabled and the last redo log file is full, why LGWR continues by overwriting the first available active file, not inactive file?

Question about 'user process' in the context of Oracle

Can I store half of a record on one page and half of the record on another page?

SQL Server restore sequence from multiple full, diff and log backups