User garik

86 votes

13 answers

76k views

How should I best name my timestamp fields?

asked May 12, 2011 at 12:29

39 votes

5 answers

155k views

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

asked Sep 2, 2011 at 7:40

29 votes

5 answers

30k views

How do I switch off SCHEMABINDING for a view without recreating it?

asked Mar 28, 2011 at 15:52

28 votes

3 answers

38k views

Code to simulate deadlock

asked Jan 5, 2011 at 20:44

21 votes

5 answers

8k views

Is ROLLBACK a fast operation?

asked Aug 31, 2011 at 8:25

21 votes

3 answers

14k views

Is it possible to get execution call stack in a trigger?

asked Jul 13, 2011 at 12:52

20 votes

9 answers

5k views

Version control for database objects

asked Jan 25, 2012 at 8:39

20 votes

6 answers

6k views

What is SQL Server "Denali"? What's new?

asked Jan 7, 2011 at 17:33

15 votes

5 answers

49k views

How to detect any changes to a database (DDL and DML)

asked Jan 30, 2011 at 0:21

14 votes

1 answer

45k views

Database 'MyDb' is being recovered. Waiting until recovery is finished

asked Dec 12, 2011 at 11:16

12 votes

3 answers

4k views

How to change the firing order of Triggers?

asked Jan 10, 2011 at 11:48

11 votes

2 answers

8k views

Why does this query cause a deadlock?

asked Apr 4, 2011 at 16:39

11 votes

1 answer

4k views

noexpand hint for non-enterpise edition and performance

asked May 30, 2011 at 11:19

7 votes

2 answers

2k views

Using totals on aggregates to improve performance

asked May 30, 2011 at 7:57

6 votes

2 answers

464 views

How to manage my own scripts

asked Mar 9, 2011 at 9:31

6 votes

1 answer

210 views

Is my function nondeterministic one

asked Jan 20, 2011 at 13:59

6 votes

1 answer

512 views

how to improve performance by using or not using table variables

asked Jul 20, 2011 at 9:19

6 votes

1 answer

1k views

How to get text for default language

asked Aug 18, 2011 at 17:21

6 votes

2 answers

542 views

Row padding to get more performance

asked Aug 31, 2011 at 21:22

5 votes

2 answers

28k views

Why TRY CATCH does not suppress exception in trigger

asked Dec 2, 2011 at 15:30

5 votes

1 answer

126 views

Data transformation implementation

asked Jan 20, 2011 at 9:26

4 votes

2 answers

539 views

TOP X of SQL Server in MySQL Analog

asked Feb 7, 2011 at 10:20

4 votes

2 answers

2k views

Performance degradation after rebuilding indexes

asked Mar 5, 2012 at 12:06

4 votes

4 answers

10k views

How to move data from big table

asked Oct 19, 2011 at 21:53

4 votes

1 answer

714 views

Locking, deadlocking workaround while process data at the same table

asked Aug 25, 2011 at 14:23

3 votes

3 answers

509 views

How to determinate in a trigger direct inserts and inserts via stored procedure

asked Jul 13, 2011 at 12:58

3 votes

2 answers

4k views

How to check that stored procedure is valid

asked Mar 29, 2011 at 7:35

2 votes

1 answer

2k views

Inner cursor performance issues

asked May 16, 2011 at 14:45

2 votes

5 answers

8k views

How to restore database using old full backup and current log file

asked Jan 26, 2011 at 10:56

2 votes

1 answer

645 views

Clustered monotonically increased index insert performance

asked Sep 1, 2011 at 9:40

Stack Exchange Network

34 Questions

How should I best name my timestamp fields?

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

How do I switch off SCHEMABINDING for a view without recreating it?

Code to simulate deadlock

Is ROLLBACK a fast operation?

Is it possible to get execution call stack in a trigger?

Version control for database objects

What is SQL Server "Denali"? What's new?

How to detect any changes to a database (DDL and DML)

Database 'MyDb' is being recovered. Waiting until recovery is finished

How to change the firing order of Triggers?

Why does this query cause a deadlock?

noexpand hint for non-enterpise edition and performance

Using totals on aggregates to improve performance

How to manage my own scripts

Is my function nondeterministic one

how to improve performance by using or not using table variables

How to get text for default language

Row padding to get more performance

Why TRY CATCH does not suppress exception in trigger

Data transformation implementation

TOP X of SQL Server in MySQL Analog

Performance degradation after rebuilding indexes

How to move data from big table

Locking, deadlocking workaround while process data at the same table

How to determinate in a trigger direct inserts and inserts via stored procedure

How to check that stored procedure is valid

Inner cursor performance issues

How to restore database using old full backup and current log file

Clustered monotonically increased index insert performance