User JHFB

462

votes

2

answers

242k

views

What's the difference between a temp table and table variable in SQL Server?

Dec 8 at 17:08 Glorfindel 1,576

87

votes

6

answers

76k

views

Why would SET ARITHABORT ON dramatically speed up a query?

sql-server

Dec 14 '18 at 14:52 Brian 185

47

votes

2

answers

104k

views

When To Update Statistics?

sql-server performance maintenance statistics

Apr 12 '15 at 19:05 Community♦ 1

46

votes

5

answers

65k

views

When is it OK to shrink a Database?

sql-server disk-space maintenance shrink

May 6 '19 at 11:35 Aaron Bertrand 170k

40

votes

3

answers

4k

views

Unexpected scans during delete operation using WHERE IN

sql-server-2008-r2 query optimization

Nov 10 '19 at 9:48 Paul White♦ 58.5k

31

votes

2

answers

279k

views

oracle - list users with access to certain tables

oracle select permissions role

Mar 12 '13 at 9:56 Community♦ 1

31

votes

2

answers

8k

views

How to make a transition from SQL Server DBA to Oracle?

sql-server oracle

Sep 2 '14 at 16:18 Community♦ 1

24

votes

3

answers

7k

views

Should I stop transaction log backups during a full backup?

sql-server backup sql-server-2008-r2

Jun 1 '18 at 3:12 TheGameiswar 2,779

24

votes

8

answers

104k

views

Login failed for user - Error 18456 - Severity 14, State 38

sql-server errors logins

Dec 9 at 14:15 Max Vernon♦ 64k

23

votes

6

answers

9k

views

Needing A Database Design Book [closed]

database-design

Nov 25 '18 at 22:05 Community♦ 1

21

votes

2

answers

5k

views

Index vs. partition

oracle performance

Mar 18 '11 at 9:04 Marian 14.4k

18

votes

4

answers

20k

views

SQL Server Max Memory not limiting use of RAM

sql-server-2008 memory

Mar 24 '15 at 19:25 Community♦ 1

16

votes

6

answers

5k

views

Is database normalization dead? [closed]

database-design normalization

Dec 14 '15 at 23:03 Community♦ 1

15

votes

3

answers

474

views

What are the canonical NoSQL resources for people who never used this technology?

nosql

Feb 2 '15 at 21:49 Aaron 3,007

14

votes

2

answers

2k

views

Where can I find the SQL standard document?

sql-standard

May 29 '15 at 15:01 Max Vernon♦ 64k

14

votes

1

answer

1k

views

Behavior of data in indexes based on fill factor

sql-server sql-server-2008-r2 index fill-factor

Apr 2 '12 at 18:08 Thomas Stringer 40.3k

13

votes

2

answers

9k

views

Deadlock error isn't returning the deadlock SQL

sql-server-2008 deadlock

Feb 13 '20 at 15:53 Marcello Miorelli 13.4k

12

votes

3

answers

10k

views

SQL Server 2008 R2 “Ghost Memory”?

sql-server-2008-r2 memory process

Nov 4 '17 at 1:18 Evan Carroll 47.9k

12

votes

1

answer

1k

views

What does a SQL Server DBA need to know about Windows Server?

sql-server windows

Nov 7 '19 at 11:42 Community♦ 1

11

votes

1

answer

1k

views

Why does 10^37 / 1 throw an arithmetic overflow error?

sql-server sql-server-2008 datatypes

Jun 11 '12 at 16:51 Community♦ 1

8

votes

2

answers

4k

views

Transaction Log and mirroring - looking for dumbest explanation possible

sql-server mirroring transaction-log

Apr 29 '15 at 10:52 Shanky 17.2k

8

votes

2

answers

521

views

Parameter sniffing work arounds

sql-server parameter-sniffing

Apr 21 '18 at 23:06 Paul White♦ 58.5k

8

votes

2

answers

1k

views

Do agile software development approaches apply to SQL?

database-agnostic design-pattern development learning

Oct 29 '18 at 9:46 Paul White♦ 58.5k

8

votes

2

answers

27k

views

How Does Oracle Handle Multiple Concurrent INSERTs Against One Table

oracle insert

Nov 18 '13 at 21:30 Community♦ 1

7

votes

2

answers

1k

views

Parameter Sniffing: Why Does This Become An Issue?

sql-server stored-procedures performance parameter query-performance

Mar 28 '17 at 18:25 Community♦ 1

7

votes

3

answers

890

views

Prevent Data Sources from being deployed outside designated folder

sql-server sql-server-2008 ssrs

Apr 12 '12 at 7:21 gbn 67.6k

7

votes

2

answers

356

views

Summary of locks for a query

sql-server-2008 locking

May 22 '12 at 8:09 Remus Rusanu 49.7k

6

votes

2

answers

3k

views

Passing values to variables defined in SSIS package at run time

sql-server ssis

Sep 13 '12 at 16:21 Zane 3,451

6

votes

1

answer

44k

views

temporary table inside procedure oracle

oracle oracle-11g temporary-tables

Feb 7 '13 at 15:43 Martin Schröder 155

5

votes

3

answers

192

views

Schemas and user rights

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

Aug 10 '12 at 8:01 mrdenny 26.5k

Stack Exchange Network

current community

your communities

more stack exchange communities

Next privilege

Next badge

41 Bookmarks

What's the difference between a temp table and table variable in SQL Server?

Why would SET ARITHABORT ON dramatically speed up a query?

When To Update Statistics?

When is it OK to shrink a Database?

Unexpected scans during delete operation using WHERE IN

oracle - list users with access to certain tables

How to make a transition from SQL Server DBA to Oracle?

Should I stop transaction log backups during a full backup?

Login failed for user - Error 18456 - Severity 14, State 38

Needing A Database Design Book [closed]

Index vs. partition

SQL Server Max Memory not limiting use of RAM

Is database normalization dead? [closed]

What are the canonical NoSQL resources for people who never used this technology?

Where can I find the SQL standard document?

Behavior of data in indexes based on fill factor

Deadlock error isn't returning the deadlock SQL

SQL Server 2008 R2 “Ghost Memory”?

What does a SQL Server DBA need to know about Windows Server?

Why does 10^37 / 1 throw an arithmetic overflow error?

Transaction Log and mirroring - looking for dumbest explanation possible

Parameter sniffing work arounds

Do agile software development approaches apply to SQL?

How Does Oracle Handle Multiple Concurrent INSERTs Against One Table

Parameter Sniffing: Why Does This Become An Issue?

Prevent Data Sources from being deployed outside designated folder

Summary of locks for a query

Passing values to variables defined in SSIS package at run time

temporary table inside procedure oracle

Schemas and user rights