User garik

142

votes

12

answers

81k

views

Should binary files be stored in the database?

database-design blob

Jan 9 '19 at 6:20 Evan Carroll 49.6k

117

votes

7

answers

128k

views

How to determine if an Index is required or necessary

sql-server performance index optimization

Jan 4 at 10:45 jitbit 623

104

votes

9

answers

40k

views

Where are some useful SQL puzzles to teach SQL in a workplace?

learning

Dec 19 '19 at 21:52 testerab 477

78

votes

5

answers

75k

views

What risks are there if we enable read committed snapshot in sql-server?

sql-server sql-server-2005 transaction

Dec 11 '19 at 20:15 Anne Cao 1

71

votes

6

answers

43k

views

What are the differences between NoSQL and a traditional RDBMS?

nosql rdbms database-recommendation

May 17 '16 at 23:02 Community♦ 1

68

votes

5

answers

11k

views

How can a group track database schema changes?

mysql version-control schema

Aug 16 '17 at 9:08 mbx 103

67

votes

7

answers

65k

views

Writing a simple bank schema: How should I keep my balances in sync with their transaction history?

sql-server sql-server-2008 database-design aggregate materialized-view

Apr 4 '19 at 8:27 Paul White♦ 59.7k

59

votes

12

answers

258k

views

Passing array parameters to a stored procedure

sql-server sql-server-2008

Mar 23 at 19:42 Charlieface 906

59

votes

6

answers

83k

views

When should I rebuild indexes?

sql-server index-maintenance

Dec 15 '17 at 6:36 Community♦ 1

50

votes

4

answers

15k

views

What are Objective Business Reasons to Prefer SQL Server 2012 over 2008 R2?

sql-server sql-server-2008 sql-server-2008-r2 sql-server-2012

May 8 '20 at 2:19 Aaron Bertrand 171k

45

votes

9

answers

6k

views

How should deletions be handled in the database?

database-design delete audit

Aug 7 '19 at 12:58 David Spillett 28k

45

votes

11

answers

60k

views

How do I copy a table with SELECT INTO but ignore the IDENTITY property?

sql-server sql-server-2005 identity

Sep 22 at 17:06 Viraj Sandaruwan 1

44

votes

5

answers

36k

views

Is nested view a good database design?

sql-server performance database-design view

Jul 23 '19 at 15:38 Erik Darling 31k

42

votes

3

answers

51k

views

Why is my database still fragmented after I rebuilt and reindexed everything?

sql-server-2008 index fragmentation

Sep 5 '11 at 10:45 Marian 14.5k

39

votes

4

answers

8k

views

On a dedicated database server, how much memory to reserve for the OS?

sql-server windows memory

Dec 29 '13 at 16:39 Troy 390

39

votes

6

answers

62k

views

How to execute SQL against all DBs on a Server

sql-server

Nov 20 '17 at 8:49 Paul 1,403

38

votes

4

answers

43k

views

Hard and Fast rule for include columns in index

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

May 27 '15 at 21:46 Community♦ 1

38

votes

5

answers

136k

views

Logical operators OR AND in condition and order of conditions in WHERE

sql-server sql-server-2008 t-sql optimization condition

Sep 4 '19 at 9:59 Community♦ 1

37

votes

10

answers

8k

views

How can I track database dependencies?

sql-server management

Sep 13 '13 at 11:04 Community♦ 1

37

votes

6

answers

6k

views

The smallest backup possible … with SQL Server

sql-server sql-server-2008 backup

Apr 7 '14 at 5:04 Community♦ 1

36

votes

2

answers

4k

views

Why are Denali sequences supposed to perform better than identity columns?

sql-server sql-server-2012 sequence

Apr 20 '16 at 12:40 Community♦ 1

31

votes

1

answer

14k

views

Designing a platform: one database or multiple databases?

database-design deployment

Oct 21 '11 at 18:56 Mark Storey-Smith 30.8k

31

votes

5

answers

2k

views

Is there a “best-practices” type process for developers to follow for database changes?

sql-server-2008 process source-control

May 15 '20 at 23:08 Oleksii Gubanov 1

30

votes

10

answers

1k

views

What is an effective way of labeling columns in a database?

database-design erd

Mar 27 '18 at 19:58 Evan Carroll 49.6k

29

votes

4

answers

105k

views

How to find out who deleted some data SQL Server

sql-server transaction delete audit

Aug 9 '19 at 19:00 Randi Vertongen 15.6k

27

votes

3

answers

35k

views

Code to simulate deadlock

sql-server deadlock

Dec 20 '16 at 15:51 Tom V 15.3k

27

votes

4

answers

16k

views

SQL Server “empty table” is slow after deleting all (12 million) records?

sql-server sql-server-2008

Mar 8 '12 at 2:33 Community♦ 1

26

votes

3

answers

16k

views

Mnesia: advantages and differences

feature-comparison

Nov 21 '13 at 13:58 Community♦ 1

26

votes

3

answers

18k

views

What are some best practices for using schemas in SQL Server?

sql-server sql-server-2008 schema

Jun 18 '18 at 14:03 Community♦ 1

25

votes

8

answers

26k

views

Tool to generate large datasets of test data [closed]

mysql tools performance performance-testing

Oct 3 '13 at 14:28 Community♦ 1

Stack Exchange Network

current community

your communities

more stack exchange communities

Next privilege

Next badge

143 Bookmarks

Should binary files be stored in the database?

How to determine if an Index is required or necessary

Where are some useful SQL puzzles to teach SQL in a workplace?

What risks are there if we enable read committed snapshot in sql-server?

What are the differences between NoSQL and a traditional RDBMS?

How can a group track database schema changes?

Writing a simple bank schema: How should I keep my balances in sync with their transaction history?

Passing array parameters to a stored procedure

When should I rebuild indexes?

What are Objective Business Reasons to Prefer SQL Server 2012 over 2008 R2?

How should deletions be handled in the database?

How do I copy a table with SELECT INTO but ignore the IDENTITY property?

Is nested view a good database design?

Why is my database still fragmented after I rebuilt and reindexed everything?

On a dedicated database server, how much memory to reserve for the OS?

How to execute SQL against all DBs on a Server

Hard and Fast rule for include columns in index

Logical operators OR AND in condition and order of conditions in WHERE

How can I track database dependencies?

The smallest backup possible … with SQL Server

Why are Denali sequences supposed to perform better than identity columns?

Designing a platform: one database or multiple databases?

Is there a “best-practices” type process for developers to follow for database changes?

What is an effective way of labeling columns in a database?

How to find out who deleted some data SQL Server

Code to simulate deadlock

SQL Server “empty table” is slow after deleting all (12 million) records?

Mnesia: advantages and differences

What are some best practices for using schemas in SQL Server?

Tool to generate large datasets of test data [closed]