jrara's user avatar
jrara's user avatar
jrara's user avatar
jrara
  • Member for 11 years, 4 months
  • Last seen more than 2 years ago
70 votes
3 answers
55k views

What is the difference between a connection and a session?

62 votes
6 answers
85k views

Why not use a table instead of a materialized view?

35 votes
4 answers
34k views

Should dbo schema be avoided?

32 votes
3 answers
38k views

Why index REBUILD does not reduce index fragmentatation?

29 votes
3 answers
174k views

How to transfer data using expdp and impdp commands?

21 votes
2 answers
26k views

What is blocking and how does it happen?

19 votes
3 answers
4k views

Is there a reason to update statistics manually?

12 votes
1 answer
52k views

Difference between database dump (export) and database backup?

12 votes
2 answers
372k views

How to resolve ORA-01031: insufficient privileges error on Windows installation?

11 votes
3 answers
9k views

Will the transaction log shrink automagically in SQL Server?

10 votes
4 answers
12k views

Is Oracle more demanding environment for a DBA than SQL Server? [closed]

9 votes
2 answers
9k views

SQL Server: how to avoid sysadmin rights but give adequate rights

9 votes
3 answers
20k views

How to free SQL Server memory?

8 votes
4 answers
258 views

SQL Server: what is the reason to favor customized database roles over fixed ones?

8 votes
7 answers
7k views

SQL Server: why to use a backup device?

7 votes
4 answers
3k views

SQL Server: what should be done when a process is blocking another process?

7 votes
1 answer
14k views

How to create a partitioned table based on date?

7 votes
4 answers
4k views

How to document Oracle database?

7 votes
2 answers
1k views

Correlated subquery and join: still the same exectution plan?

6 votes
1 answer
2k views

SQL Server: How to create a table that fills one 8 KB page?

6 votes
1 answer
4k views

SQL Server: hierarchy of permissions for schema?

6 votes
3 answers
342 views

Is there some drawback to define SPARSE columns?

6 votes
2 answers
13k views

What is SQL Server Parallel Data Warehouse?

6 votes
2 answers
175 views

Is is possible to manage SQL Server 2008 databases via R2 Management Studio?

6 votes
2 answers
13k views

How to deny drop permission for a table?

5 votes
2 answers
12k views

Is it possible to assign sql logins into a group?

5 votes
3 answers
4k views

Is it good idea to change Simple Recover Model into Bulk-Logged on ETL system?

5 votes
5 answers
22k views

Small sample database for practicing database administration?

5 votes
3 answers
3k views

How to select a subset of data from a large ER model?

5 votes
3 answers
9k views

What's the difference between Linked Server solution and SSIS solution?