user avatar
user avatar
user avatar
Just a learner
  • Member for 11 years
  • Last seen more than a month ago
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?

23 votes
4 answers
177k views

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

13 votes
1 answer
2k views

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

11 votes
1 answer
25k views

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

10 votes
2 answers
9k views

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

7 votes
3 answers
4k views

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

7 votes
3 answers
18k views

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

6 votes
1 answer
9k views

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

6 votes
3 answers
375 views

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

6 votes
2 answers
20k views

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

5 votes
1 answer
9k views

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

5 votes
1 answer
6k views

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

5 votes
1 answer
4k views

Understanding of SQL Server active/active cluster

5 votes
2 answers
604 views

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

4 votes
2 answers
3k views

Question on Oracle rowid column in every table

3 votes
3 answers
1k views

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

3 votes
2 answers
8k views

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

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

3 votes
1 answer
3k views

Oracle permission issue

3 votes
1 answer
66 views

MySQL Download Question

3 votes
3 answers
534 views

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

3 votes
2 answers
5k views

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

3 votes
1 answer
366 views

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

3 votes
2 answers
640 views

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

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?

2 votes
2 answers
118 views

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

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?

2 votes
3 answers
2k views

Question about 'user process' in the context of Oracle

2 votes
2 answers
871 views

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

2 votes
3 answers
2k views

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