User garik

133

votes

12

answers

66k

views

Should binary files be stored in the database?

database-design blob

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

111

votes

6

answers

119k

views

How to determine if an Index is required or necessary

sql-server performance index optimization

Aug 23 at 15:39 Peter Vandivier 3,158

101

votes

9

answers

38k

views

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

learning

Dec 19 at 21:52 testerab 477

73

votes

5

answers

71k

views

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

sql-server sql-server-2005 transaction

Dec 11 at 20:15 Anne Cao 1

71

votes

6

answers

42k

views

What are the differences between NoSQL and a traditional RDBMS?

nosql rdbms database-recommendation

May 17 '16 at 23:02 Joel Handwell 103

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

60

votes

7

answers

57k

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 9♦ 52.9k

57

votes

6

answers

76k

views

When should I rebuild indexes?

sql-server index-maintenance

Dec 15 '17 at 6:36 Greg 2,883

54

votes

11

answers

222k

views

Passing array parameters to a stored procedure

sql-server sql-server-2008

May 20 '17 at 15:44 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 2 '12 at 18:17 A-K 6,814

44

votes

9

answers

5k

views

How should deletions be handled in the database?

database-design delete audit

Aug 7 at 12:58 David Spillett 25.4k

43

votes

10

answers

51k

views

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

sql-server sql-server-2005 identity

Mar 1 '18 at 4:47 Paul White 9♦ 52.9k

43

votes

5

answers

31k

views

Is nested view a good database design?

sql-server performance database-design view

Jul 23 at 15:38 Erik Darling 29.8k

41

votes

3

answers

48k

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.1k

39

votes

4

answers

7k

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 370

39

votes

6

answers

55k

views

How to execute SQL against all DBs on a Server

sql-server

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

38

votes

4

answers

42k

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

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

35

votes

5

answers

124k

views

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

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

Sep 4 at 9:59 Community♦ 1

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

Jun 22 '18 at 16:32 Beth Whitezel 952

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.3k

30

votes

10

answers

914

views

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

database-design erd

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

29

votes

4

answers

97k

views

How to find out who deleted some data SQL Server

sql-server transaction delete audit

Aug 9 at 19:00 Randi Vertongen 14.8k

27

votes

4

answers

15k

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

25

votes

8

answers

12k

views

Why is it a bad practice to allow everyone to use the sa login?

sql-server security

May 15 '14 at 18:25 Ivan Stankovic 637

25

votes

3

answers

32k

views

Code to simulate deadlock

sql-server deadlock

Dec 20 '16 at 15:51 Tom V - try topanswers.xyz 15.1k

25

votes

8

answers

22k

views

Tool to generate large datasets of test data [closed]

mysql tools performance performance-testing

Oct 3 '13 at 14:28 Community♦ 1

24

votes

3

answers

12k

views

Why is `SELECT @@IDENTITY` returning a decimal?

sql-server t-sql ado.net

Aug 17 '11 at 14:42 Community♦ 1

Stack Exchange Network

current community

your communities

more stack exchange communities

Next privilege

Next badge

142 Favorites

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?

When should I rebuild indexes?

Passing array parameters to a stored procedure

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

How can I track database dependencies?

The smallest backup possible … with SQL Server

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

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

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

Designing a platform: one database or multiple databases?

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

How to find out who deleted some data SQL Server

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

Why is it a bad practice to allow everyone to use the sa login?

Code to simulate deadlock

Tool to generate large datasets of test data [closed]

Why is `SELECT @@IDENTITY` returning a decimal?