User garik

12

71

votes

12

answers

51k

views

How should I best name my timestamp fields?

naming-convention

Jul 25 at 13:42 Traycho Ivanov 121

8

37

votes

5

answers

134k

views

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

Sep 4 '19 at 9:59 Community♦ 1

13

27

votes

3

answers

34k

views

Code to simulate deadlock

sql-server deadlock

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

4

23

votes

4

answers

27k

views

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

sql-server sql-server-2008 view

Jan 15 '18 at 13:08 David Roodman 21

3

20

votes

5

answers

7k

views

Is ROLLBACK a fast operation?

sql-server-2008 performance transaction rdbms rollback

Mar 25 '19 at 21:02 Aaron Bertrand 170k

8

19

votes

6

answers

6k

views

What is SQL Server “Denali”? What's new?

features sql-server-2012

May 12 at 14:46 Aaron Bertrand 170k

6

19

votes

9

answers

5k

views

Version control for database objects

sql-server sql-server-2008-r2 version-control source-control

Feb 11 '15 at 15:16 jlee-tessik 109

5

17

votes

3

answers

12k

views

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

sql-server-2008 trigger

Aug 11 '19 at 15:54 Basil Kisel 83

5

15

votes

5

answers

45k

views

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

sql-server-2008 backup trigger

Jan 31 at 9:16 Glorfindel 1,614

3

14

votes

1

answer

39k

views

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

sql-server sql-server-2008-r2 recovery

Dec 1 '13 at 12:07 Community♦ 1

1

12

votes

3

answers

4k

views

How to change the firing order of Triggers?

sql-server-2008 sql-server-2005 trigger

Oct 4 '11 at 18:15 Nick Chammas 13.7k

3

11

votes

2

answers

8k

views

Why does this query cause a deadlock?

sql-server-2008 deadlock

May 8 at 19:57 Aaron Bertrand 170k

11

votes

1

answer

4k

views

noexpand hint for non-enterpise edition and performance

sql-server-2008 performance clustered-index view

Nov 14 '18 at 15:01 gbn 67.8k

7

votes

2

answers

2k

views

Using totals on aggregates to improve performance

sql-server-2008 performance aggregate query materialized-view

May 31 '11 at 13:46 Community♦ 1

1

6

votes

1

answer

1k

views

How to get text for default language

sql-server-2008 query t-sql cte

Sep 27 '11 at 21:59 Nick Chammas 13.7k

6

votes

2

answers

472

views

Row padding to get more performance

sql-server performance

Sep 1 '11 at 15:24 Aaron Bertrand 170k

6

votes

1

answer

498

views

how to improve performance by using or not using table variables

sql-server-2008 performance execution-plan

Jul 20 '11 at 11:10 garik 6,382

6

votes

2

answers

432

views

How to manage my own scripts

best-practices scripting

Mar 9 '11 at 12:35 Marian 14.5k

6

votes

1

answer

198

views

Is my function nondeterministic one

sql-server performance determinism

Jan 20 '11 at 14:19 Eric Humphrey - lotsahelp 4,863

2

5

votes

2

answers

23k

views

Why TRY CATCH does not suppress exception in trigger

sql-server-2008 trigger error-handling

Apr 9 '18 at 20:41 Community♦ 1

5

votes

1

answer

118

views

Data transformation implementation

sql-server-2008 performance database-design database-recommendation

Jan 20 '11 at 14:46 garik 6,382

1

4

votes

4

answers

9k

views

How to move data from big table

sql-server sql-server-2008-r2

Sep 4 at 15:37 Mike Lewis 111

4

votes

2

answers

1k

views

Performance degradation after rebuilding indexes

sql-server-2008 performance index statistics

Mar 5 '12 at 13:00 James L 4,138

4

votes

1

answer

663

views

Locking, deadlocking workaround while process data at the same table

sql-server-2008 transaction deadlock locking hints

Aug 25 '11 at 22:10 Simon Hughes 588

4

votes

2

answers

509

views

TOP X of SQL Server in MySQL Analog

mysql

Aug 16 '11 at 18:09 Community♦ 1

3

votes

3

answers

499

views

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

sql-server-2008 trigger

Jul 13 '11 at 17:35 gbn 67.8k

3

votes

2

answers

4k

views

How to check that stored procedure is valid

sql-server-2008 database-recommendation maintenance

Mar 29 '11 at 9:03 Marian 14.5k

1

2

votes

5

answers

7k

views

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

sql-server-2008 restore

Feb 15 '17 at 17:40 animuson♦ 101

1

2

votes

1

answer

12k

views

Changed database context to 'MyDbName'

sql-server-2008-r2 error-handling

Dec 14 '11 at 15:12 Community♦ 1

2

votes

1

answer

585

views

Clustered monotonically increased index insert performance

sql-server-2008 performance execution-plan clustered-index clustered-primary-key

Nov 10 '11 at 21:44 Community♦ 1

Stack Exchange Network

current community

your communities

more stack exchange communities

Next privilege

Next badge

34 Questions

How should I best name my timestamp fields?

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

Code to simulate deadlock

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

Is ROLLBACK a fast operation?

What is SQL Server “Denali”? What's new?

Version control for database objects

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

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 get text for default language

Row padding to get more performance

how to improve performance by using or not using table variables

How to manage my own scripts

Is my function nondeterministic one

Why TRY CATCH does not suppress exception in trigger

Data transformation implementation

How to move data from big table

Performance degradation after rebuilding indexes

Locking, deadlocking workaround while process data at the same table

TOP X of SQL Server in MySQL Analog

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

How to check that stored procedure is valid

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

Changed database context to 'MyDbName'

Clustered monotonically increased index insert performance