User jrara - Database Administrators Stack Exchange

bio	website
	location
	age
visits	member for	2 years
	seen	44 mins ago
stats	profile views	57

	1,255 reputation	bio	website		visits	member for	2 years
736 badges		location			seen	44 mins ago

6

14

votes

4

answers

1

kviews

Why not use a table instead of a materialized view?

aug 28 at 15:44 billinkc 2,726

13

votes

2

answers

1

kviews

What is the difference between a connection and a session?

sql-server

feb 22 '12 at 20:10 Remus Rusanu 22.1k

1

10

votes

4

answers

4

kviews

Should dbo schema be avoided?

sql-server sql-server-2008 schema best-practices

dec 7 '11 at 21:27 DForck42 978

4

9

votes

4

answers

2

kviews

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

sql-server oracle

aug 22 '11 at 19:04 Razvan Popovici 123

1

8

votes

2

answers

1

kviews

What is blocking and how does it happen?

sql-server locking

aug 18 '11 at 22:13 Richard 2,695

1

7

votes

3

answers

2

kviews

Is there a reason to update statistics manually?

sql-server statistics

feb 21 at 18:35 Aaron Bertrand♦ 37.7k

7

votes

3

answers

2

kviews

How to free SQL Server memory?

sql-server memory

jun 12 '12 at 21:31 Martin Smith 17.9k

1

6

votes

3

answers

446

views

How to document Oracle database?

oracle metadata documentation

sep 27 at 12:30 Max Vernon 4,272

6

votes

2

answers

1

kviews

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

sql-server security

aug 27 '11 at 21:39 Aaron Bertrand♦ 37.7k

6

votes

4

answers

175

views

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

sql-server security

aug 23 '11 at 19:27 gbn 43.4k

1

6

votes

4

answers

628

views

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

sql-server locking

aug 21 '11 at 1:05 jcolebrand♦ 3,847

5

votes

1

answer

358

views

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

oracle windows sqlplus windows-server

mar 29 at 9:09 Colin 't Hart 1,206

5

votes

2

answers

232

views

Correlated subquery and join: still the same exectution plan?

sql sql-server-2008-r2 query execution-plan

aug 26 at 15:21 BillThor 2,035

1

5

votes

2

answers

959

views

Why index REBUILD does not reduce index fragmentatation?

sql-server index clustered-index fragmentation

may 24 '12 at 19:28 JNK♦ 8,951

5

votes

2

answers

134

views

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

sql-server sql-server-2008 sql-server-2008-r2 ssms

nov 2 '11 at 5:32 TroubleshootingSQL 76

2

5

votes

3

answers

2

kviews

Will the transaction log shrink automagically in SQL Server?

sql-server sql-server-2008 backup transaction shrink

oct 27 '11 at 6:13 Sathya 729

2

4

votes

1

answer

4

kviews

How to transfer data using expdp and impdp commands?

oracle schema export impdp expdp

dec 16 at 12:18 Mat 3,403

4

votes

1

answer

138

views

When should startup parameter -E be used?

sql-server sql-server-2008-r2 data-warehouse instance parameter

nov 22 at 17:39 Aaron Bertrand♦ 37.7k

4

votes

1

answer

167

views

What factors prevent and delay TRUNCATE command?

sql-server sql truncate

mar 25 '12 at 21:25 Remus Rusanu 22.1k

1

4

votes

1

answer

2

kviews

SQL Server: hierarchy of permissions for schema?

sql-server schema permissions

oct 18 '11 at 7:58 gbn 43.4k

1

4

votes

1

answer

182

views

Is there some drawback to define SPARSE columns?

sql-server null database-design disk-space

oct 4 '11 at 6:21 user973156 91

3

votes

1

answer

1

kviews

How to create a partitioned table based on date?

sql-server sql-server-2008 partitioning ddl

nov 28 at 19:34 Ali Razeghi 1,927

3

votes

2

answers

334

views

Is it possible to assign sql logins into a group?

sql-server authentication

feb 4 '12 at 2:48 Shawn Melton 3,728

3

votes

1

answer

196

views

Does blocking always mean open transaction?

sql-server sql-server-2008 transaction locking transaction-log

dec 6 '11 at 10:55 Martin Smith 17.9k

3

votes

1

answer

100

views

Why SQL Server installs multiple services for AS and RS, but only one for IS?

sql-server sql-server-2008 ssis installation instance

nov 22 '11 at 20:40 gbn 43.4k

3

votes

2

answers

2

kviews

What is SQL Server Parallel Data Warehouse?

sql-server data-warehouse

oct 25 '11 at 21:14 sqlvogel 1,660

3

votes

6

answers

1

kviews

SQL Server: why to use a backup device?

sql-server backup

oct 21 '11 at 20:23 StanleyJohns 4,305

3

votes

3

answers

2

kviews

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

sql-server sql-server-2008 linked-server

sep 13 '11 at 22:24 StanleyJohns 4,305

3

votes

3

answers

2

kviews

SQL Server: does ddladmin rights contain datareader and datawriter rights to the database?

sql-server sql-server-2008 security

aug 23 '11 at 18:43 gbn 43.4k

3

votes

1

answer

678

views

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

sql-server data-pages

jun 20 '11 at 7:33 gbn 43.4k

jrara

51 Questions